Secondary Axis

G

Guest

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.
 
A

Andy Pope

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
 
G

Guest

Yes all information has been selected.

Andy Pope said:
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
 
A

Andy Pope

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?
 
G

Guest

For now I used the custom chart type for a secondary axis line so I could get
the option to plot on the right side of the chart, not just the left. I had
to redo it but at least I got the chart created.

My problem wasn't with creating the chart but with the item that is supposed
to be on the "Format" menu. When I click Format (according to MS
instructions) after selecting my data there isn't an option called "Selected
Data Series" for me to click. If I can't click the item I can't add the
secondary axis using the instructions I found in "Help".

I would still like to know why this item isn't part of my Format menu and
how to get it added for future use.

Thanks Andy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top