View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
 
Posts: 461
Default 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