 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-05-2005, 12:38 PM
|
|||
|
|||
|
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 
|
|
#2
10-05-2005, 05:05 PM
|
|||
|
|||
|
RE: Can't make secondary axis in bar chart
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
10-06-2005, 06:05 AM
|
|||
|
|||
|
Re: Can't make secondary axis in bar chart
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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
