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

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

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

Make su

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/1/2010 11:58 AM, Meenie wrote:
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