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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
Back
Top