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
|
|||
|
|||
Dont have secondary axis option listed in Series Option
I am trying to creat a seconday axis. In Excel 2007 from the Series Options
tab on the Format Data Series prompt, I only have the following options: Gap depth and Gap width instead of primary and secondary axis. What am I doing wrong or how do I get these options |
#2
|
|||
|
|||
Dont have secondary axis option listed in Series Option
Please look at:-
http://www.pierrefondes.com/ Item number 26. What follows is said in reference to the above file (called secondary_axis). Take the following action in EXCEL 2007:- - click somewhere in one of the blue columns (on chart itself) - this will place blue circles around those columns - right hand click and select Format Data Series - Format Data Series pane should launch (and should have Series Options highlighted in the top left hand corner) - select the Secondary Axis radio button towards the bottom of the screen - Close Please hit Yes if my comments have helped. Thanks. "Venus" wrote: I am trying to creat a seconday axis. In Excel 2007 from the Series Options tab on the Format Data Series prompt, I only have the following options: Gap depth and Gap width instead of primary and secondary axis. What am I doing wrong or how do I get these options |
#3
|
|||
|
|||
Dont have secondary axis option listed in Series Option
There is another (perhaps better) example of a Secondary Axis at number 69.
Please hit Yes if my comments have helped. Thanks. "Venus" wrote: I am trying to creat a seconday axis. In Excel 2007 from the Series Options tab on the Format Data Series prompt, I only have the following options: Gap depth and Gap width instead of primary and secondary axis. What am I doing wrong or how do I get these options |
#4
|
|||
|
|||
Dont have secondary axis option listed in Series Option
You need to plot a second series in the chart in order to obtain
secondary axes. Also, 3D charts do not accommodate secondary axes. Yet another reason not to use 3D charts. - Jon ------- Jon Peltier Peltier Technical Services, Inc. 774-275-0064 http://peltiertech.com/ On 2/23/2010 12:02 PM, Venus wrote: I am trying to creat a seconday axis. In Excel 2007 from the Series Options tab on the Format Data Series prompt, I only have the following options: Gap depth and Gap width instead of primary and secondary axis. What am I doing wrong or how do I get these options |
Thread Tools | |
Display Modes | |
|
|