Charts that don't change size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelly McFaul - 06 Nov 2003 03:03 GMT

I have 2 charts on a sheet, each representing different data, one on top of
the other. I would like the plot areas to line up with each other. I can do
this easily with no data, but when data is added, one will be bigger or
smaller than the other. There is new data added every month and no matter
how hard I try to keep them aligned, they just keep changing sizes!! The
chart is not the problem, it's just the plot area.
Is there a way to lock the plot area size, whether there is data in it or
not?
Thanks

Reply to this Message

Tushar Mehta - 06 Nov 2003 11:36 GMT

I think -- but I am not sure -- you could write a macro that aligns the
plot areas. Other than that I can't think of an alternative...
except... do you really need 2 charts? Or can the contents be combined
into a customized combination chart?

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> I have 2 charts on a sheet, each representing different data, one on top of
> the other. I would like the plot areas to line up with each other. I can do
[quoted text clipped - 5 lines]
> not?
> Thanks

Reply to this Message