remove dates from chart

[Rebecca]

I am new at creation of charts. I do not have the weekends in my data but
they keep showing up in my chart? Can they be removed?
Thanks

 

[Jon Peltier]

In a line or column chart, the default axis type when Excel recognizes dates
in a time-scale axis. Change this to a category axis:

Chart menu > Chart Options > Axes tab, select Category under Primary
Category (X) Axis.

- Jon

 

[Rebecca]

Thanks

In a line or column chart, the default axis type when Excel recognizes dates
in a time-scale axis. Change this to a category axis:

Chart menu > Chart Options > Axes tab, select Category under Primary
Category (X) Axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______