Not sure I understand, sorry.
You have selected the particular column or line you want set to the
secondary axis and none of the things I suggest work?
Ann wrote:
Yes all information has been selected.
"Andy Pope" wrote:
Hi,
You sure you have the series selected?
You can also right click the series in the chart to get a popup menu to
pick Format from.
Or just double click the series.
Cheers
Andy
Ann wrote:
I need to plot a secondary axis on a chart. MS instructions for plotting
secondary series listed below. The problem is there isn't a "Selected Data
Series" on the Format menu. I am using XP, how do I get this?
When the range of values for different data series in a 2-D chart varies
widely, or when you have mixed types of data (such as price and volume), you
can plot one or more data series on a secondary value (y) axis. The scale of
the secondary axis reflects the values for the associated series.
Click the data series you want to plot along a secondary value axis.
On the Format menu, click Selected Data Series, and then click the Axis tab.
Click Secondary axis.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info