Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can't make secondary axis in bar chart
Hi - I've read several postings regarding adding a secondary axis to a bar chart, but I am having a problem. When I select the data series I want to plot on a secondary axis, the "Axis" tab does not come up, just Patterns, Shape, Data Labels, Series Order and Options. I can get it to work on a line graph, but I need this to be a bar chart. Help? Thanks -- Angivan ------------------------------------------------------------------------ Angivan's Profile: http://www.excelforum.com/member.php...o&userid=27835 View this thread: http://www.excelforum.com/showthread...hreadid=473432 |
#2
|
|||
|
|||
what version of Excel are you working with.
I have 2002 and do not have a shape tab on my data series options. when you click on the shape tab what do you see "Angivan" wrote: Hi - I've read several postings regarding adding a secondary axis to a bar chart, but I am having a problem. When I select the data series I want to plot on a secondary axis, the "Axis" tab does not come up, just Patterns, Shape, Data Labels, Series Order and Options. I can get it to work on a line graph, but I need this to be a bar chart. Help? Thanks -- Angivan ------------------------------------------------------------------------ Angivan's Profile: http://www.excelforum.com/member.php...o&userid=27835 View this thread: http://www.excelforum.com/showthread...hreadid=473432 |
#3
|
|||
|
|||
Hi,
You will have to use a 2d chart. Sounds like you currently have one of the 3d style, which is why you have the shape tab instead of the axis. Cheers Andy Angivan wrote: Hi - I've read several postings regarding adding a secondary axis to a bar chart, but I am having a problem. When I select the data series I want to plot on a secondary axis, the "Axis" tab does not come up, just Patterns, Shape, Data Labels, Series Order and Options. I can get it to work on a line graph, but I need this to be a bar chart. Help? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tick mark labels | Charts and Charting in Excel | |||
Pie-in-Pie (sort of) how can I make this chart? | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
make line in chart start at y axis | Charts and Charting in Excel | |||
How to make a stacked bar chart using time? | Charts and Charting in Excel |