Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Secondary Axis chart
I need to create a chart with two axis. I want both the data series to be
displayed as columns on the same graph. So far I have only been able to a secondary axis chart with a column and line - by going to custom charts in 'type of chart'. Anyone know how I can make both the data series appear as columns? I have also tried going to the Format menu, clicking on Selected Data Series and then clicking Secondary axis on the Axis tab. This makes one series go in front of the other though and I can't get them to go side by side so you can see both series. (Hope that made sense!) |
#2
|
|||
|
|||
Hi,
You need to alter the layout of your data slightly. For explanations of how to do this http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy McInnes wrote: I need to create a chart with two axis. I want both the data series to be displayed as columns on the same graph. So far I have only been able to a secondary axis chart with a column and line - by going to custom charts in 'type of chart'. Anyone know how I can make both the data series appear as columns? I have also tried going to the Format menu, clicking on Selected Data Series and then clicking Secondary axis on the Axis tab. This makes one series go in front of the other though and I can't get them to go side by side so you can see both series. (Hope that made sense!) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XY scatter and Bar chart - secondary axis misaligned | Charts and Charting in Excel | |||
XY scatter and Bar chart - secondary axis misaligned | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel |