If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stacked Bar Chart with Secondary Axis | Benjamin B | Charts and Charting | 7 | May 15th, 2005 04:00 AM |
How do I set permanent secondary axis in PivotTable chart? | Microlong | Charts and Charting | 3 | January 8th, 2005 03:54 AM |
How do I set up a bar chart with a secondary axis? | Buh | Charts and Charting | 1 | September 8th, 2004 06:35 PM |
Bar chart with secondary axis | George Wilson | Charts and Charting | 1 | September 1st, 2004 05:14 PM |
P & V chart: Secondary X axis gradient (again) | wlotto | Charts and Charting | 9 | March 15th, 2004 05:26 PM |