i do not see the "plot series on" option in Excel 2007

[Guest]

Hi,

I am not able to see the "Plot Series on" Option under Format Data Series /
Format layout in Excel 2007. Is there any configuration that I need to do? I
want to add a Secondary vertical axis

Thanks,
Maithily

 

[David Biddulph]

I don't have Excel 2007, but the first question is whether you have more
than one series. In 2003 it will grey out that option on the Format Data
Series/ Axis tab unless you have multiple series in the graph.

 

[Andy Pope]

Hi,

The 'Plot Series On' is on the Series Options tab of the Format Data Series
dialog.
If the chart type is of the 3d variety the option is not visible.
If the chart only has 1 series the option is visible but grayed out.

Cheers
Andy