secondary (Y) axis greyed out on Chart Options

G

Guest

I'm trying to add a secondary Y and then X axis in XP Professional, but they
are greyed out on the Chart Options Box and when I follow Excel's Help
directions, SELECTED DATA SERIES does not show up on the FORMAT tab. How
would one 'unlock' the ability to insert secondary axis' in an Excel chart?
when EXCEL HELP doesn't work?
 
J

Jon Peltier

1. What kind of chart?
2. How many series are in the chart?

You must have two series to enable adding a secondary axis, and you add it
by assigning at least one series to the secondary axis.

- Jon
 

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

Similar Threads

Chart distorts secondary axis when the x-axis is logarithmic 5
Coordinate secondary y axis to primary y axis 2
Chart - Secondary Y-axis with different values/scale 2
Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem 0
Using the full width of an Excel chart with two Y-axes 2
Secondary Axis 1
Secondary Axis 9
Secondary Axis Selected Data Series 1

Top