Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
Multiple Print areas in same sheet? | Excel Discussion (Misc queries) | |||
Copy & paste in multiple areas using VBA | Excel Discussion (Misc queries) | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions |