ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Multiple plot areas (https://www.excelbanter.com/charts-charting-excel/55770-multiple-plot-areas.html)

Katie

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

Andy Pope

Multiple plot areas
 
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


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com