extra info is showing up in my secondary x axis, I can't get rid o

M

Meenie

Excel 2003:
I have a chart with a secondary axis
the x axis is July 2009 - Jan 2010
but on the x axes at the top of the chart it's showing up as March 2009 -
January 2010
I have gone to the source, made sure it's linked to the source, re-picked
the source.
what have I done wrong? Where is it getting March from?
the new Y axis is behaving perfectly.
When I look at the scale of the primary x axis, I notice it says the base is
Months but that's not available for the secondary axis.
Can anyone help?
thanks, meenie
 
J

Jon Peltier

Make sure:

1. The top axis is the secondary one.
2. The axes have the same scale min and max.

- 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

Primary X axis to Secondary X axis 1
One extra x axis item that wont go away - can anyone help? 3
Chart distorts secondary axis when the x-axis is logarithmic 5
Overlaying 2 Data Series with Different Time (X) Axis 3
Can't get the x-axis to cross at value 0 for both y-axes 3
Set position of x axis labels 2
Excel 2007: X-axis labeling 1
Secondary y-axis for certain x-axis categories (not by series) 2

Top