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

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

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

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