Remove weekends from a stock chart

[pb]

Hi,

I'm trying to build an excel stock chart and i don't know how to remove
weekends from it. I don'd have them in the data table...but they appear in
the chart.

Thanks

 

[Jon Peltier]

If Excel recognizes your X data as dates, it constructs a date-scale axis,
which includes a spot for every date. On the Chart menu, select Options,
click on the Axes tab, and change Category (X) axis to Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

 

[GPS]

I have same question right know with Excel 2007,
Please HELP !

 

[Jon Peltier]

Basically you do the same, but they've redesigned the dialog so nobody can
find anything. I think in 2007, you have to select the X axis, press Ctrl+1
(numeral one) which is the shortcut for Format Selected Object, and find the
axis type on the first tab. The choices are Auto, Text, and Date.

- Jon

 

[GPS]

Thanks Jon,
I was simply walking over that choice and not trying it. Instead of Date
format need to use as Text format and still be linked to source and results =
no gaps on chart time line. Perfect.