remove dates from chart

R

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
 
J

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
 
R

Rebecca

Thanks

Jon Peltier said:
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
_______
Click to expand...
 
Top