E
egun
I decided to play around with sparkline charts (really tiny, simple charts)
to create some "dashboard" status tools at work, and have run into a couple
of issues:
1. When I programmatically resize the chart area to the size of the cell(s)
I want the chart to fit into, and then resize the plot area to be within that
chart area, things don't work. The plot area does get resized, but it
maintains its original aspect ratio, so I end up with a square plot area
inside the rectangular chart area, i.e. when the macro is finished, the plot
area width is smaller than what I set using the VBA code. Strangely, if I
step through the VBA code one line at a time, the end result is what I
expect. Any ideas on why it doesn't work when I run the macro straight
through?
2. If I manually resize the chart by selecting the chart area and sizing it
down to the size of the cell(s), I seem to reach a limit to how small I can
go before the plot area stops shrinking (in height), and the plot area height
ends up larger than the chart area height, so the graph is clipped on the
bottom. Again, any ideas?
Is there a good source that explains the relationship between chart area and
plot area?
I have looked at several of the sample offerings on the web. I'm using
Excel 2003 at work, although they're going to force 2007 on me soon...
Thanks,
Eric
to create some "dashboard" status tools at work, and have run into a couple
of issues:
1. When I programmatically resize the chart area to the size of the cell(s)
I want the chart to fit into, and then resize the plot area to be within that
chart area, things don't work. The plot area does get resized, but it
maintains its original aspect ratio, so I end up with a square plot area
inside the rectangular chart area, i.e. when the macro is finished, the plot
area width is smaller than what I set using the VBA code. Strangely, if I
step through the VBA code one line at a time, the end result is what I
expect. Any ideas on why it doesn't work when I run the macro straight
through?
2. If I manually resize the chart by selecting the chart area and sizing it
down to the size of the cell(s), I seem to reach a limit to how small I can
go before the plot area stops shrinking (in height), and the plot area height
ends up larger than the chart area height, so the graph is clipped on the
bottom. Again, any ideas?
Is there a good source that explains the relationship between chart area and
plot area?
I have looked at several of the sample offerings on the web. I'm using
Excel 2003 at work, although they're going to force 2007 on me soon...
Thanks,
Eric