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

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
_______

"pb" wrote in message
...
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

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

"Jon Peltier" wrote:

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
_______

"pb" wrote in message
...
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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"GPS" wrote in message
...
I have same question right know with Excel 2007,
Please HELP !

"Jon Peltier" wrote:

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
_______

"pb" wrote in message
...
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

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.

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"GPS" wrote in message
...
I have same question right know with Excel 2007,
Please HELP !

"Jon Peltier" wrote:

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
_______

"pb" wrote in message
...
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