Charts that don't change size

K

Kelly McFaul

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
 
T

Tushar Mehta

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?

--
Regards,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Plot Area changes in Excel 2007 0
Embed the same Excel multiple times 0
Plot area changed after reopen document 0
Chart type for machine timing diagram? 3
change chart primary horizontal axis label or name 1
Display Data Table in chart but don't show plot area 2
How can the font and size of (all) citation numbers be altered? 1
Seemingly random plot area drift? 2

Top