Charts that don't change size

  • Thread starter Thread starter Kelly McFaul
  • Start date Start date
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
 
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
 
Back
Top