Multiple plot areas

I am trying to create a figure consisting of four graphs, displayed beneath
each other. I want them to share the same xaxis (time) as they each display a
different variable as a function of the same time period. I need the plot
areas to be the same width across so that the variables can be compared. I
have tried to copy the chart and use paste special and format, but this still
allows for differences in the plot width. Even if the xaxis is repeated on
each graph it doesnt matter, i just need the width and scale to be the same
so i can compare each graph. Help!
--
Katie

Hi,

Have a look at Jon Peltier's example of stacking charts.
http://peltiertech.com/Excel/Charts/StackedCharts.html

Cheers
Andy

Katie wrote:
> I am trying to create a figure consisting of four graphs, displayed beneath
> each other. I want them to share the same xaxis (time) as they each display a
> different variable as a function of the same time period. I need the plot
> areas to be the same width across so that the variables can be compared. I
> have tried to copy the chart and use paste special and format, but this still
> allows for differences in the plot width. Even if the xaxis is repeated on
> each graph it doesnt matter, i just need the width and scale to be the same
> so i can compare each graph. Help!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info