Make several charts same size?

  • Thread starter Thread starter Terry Pinnell
  • Start date Start date
T

Terry Pinnell

I've made four very simple column charts from four lines of data, each
in its own window. But I want to reduce their sizes (particularly
their heights). Easy - just drag a corner. But how do I ensure that
they are exactly the same dimensions please? (I also want their
formats to be identical, but expect that will be easy.)

I must get this done today (they will be images for a web site) so
would much appreciate advice please.
 
Debra Dalgleish said:
Jon Peltier has code for resizing and moving charts:

http://www.peltiertech.com/Excel/ChartsHowTo/ResizeAndMoveAChart.html

At the end of his Chart Types article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=299

Jon discusses Custom Chart types, and copying formats from charts.
Click to expand...

Thanks, Debra. I may take a look at that. Meanwhile I presed on and
did the job by brute force - visual inspection!

The resulting consolidated GIF is about half way down the page
http://www.cupod-mentoring.com/ianswinglerproject.htm
 
Back
Top