secondary (Y) axis greyed out on Chart Options

J

JON

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
Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem 0
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Using the full width of an Excel chart with two Y-axes 2
Chart - Secondary Y-axis with different values/scale 2
Scatter chart with categories on x-Axis 2
extra info is showing up in my secondary x axis, I can't get rid o 1

Top