software

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;pbquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I'm trying to build an excel stock chart and i don't know how to remove
gt; weekends from it. I don'd have them in the data table...but they appear in
gt; the chart.
gt;
gt; Thanks
I have same question right know with Excel 2007,
Please HELP !

quot;Jon Peltierquot; wrote:

gt; If Excel recognizes your X data as dates, it constructs a date-scale axis,
gt; which includes a spot for every date. On the Chart menu, select Options,
gt; click on the Axes tab, and change Category (X) axis to Category.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;pbquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I'm trying to build an excel stock chart and i don't know how to remove
gt; gt; weekends from it. I don'd have them in the data table...but they appear in
gt; gt; the chart.
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;

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
PeltierTech.com
_______quot;GPSquot; gt; wrote in message
...
gt;I have same question right know with Excel 2007,
gt; Please HELP !
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; If Excel recognizes your X data as dates, it constructs a date-scale
gt;gt; axis,
gt;gt; which includes a spot for every date. On the Chart menu, select Options,
gt;gt; click on the Axes tab, and change Category (X) axis to Category.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;pbquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; I'm trying to build an excel stock chart and i don't know how to remove
gt;gt; gt; weekends from it. I don'd have them in the data table...but they appear
gt;gt; gt; in
gt;gt; gt; the chart.
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt;
gt;gt;
gt;gt;
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.

quot;Jon Peltierquot; wrote:

gt; Basically you do the same, but they've redesigned the dialog so nobody can
gt; find anything. I think in 2007, you have to select the X axis, press Ctrl 1
gt; (numeral one) which is the shortcut for Format Selected Object, and find the
gt; axis type on the first tab. The choices are Auto, Text, and Date.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Tutorials and Custom Solutions
gt; PeltierTech.com
gt; _______
gt;
gt;
gt; quot;GPSquot; gt; wrote in message
gt; ...
gt; gt;I have same question right know with Excel 2007,
gt; gt; Please HELP !
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt; If Excel recognizes your X data as dates, it constructs a date-scale
gt; gt;gt; axis,
gt; gt;gt; which includes a spot for every date. On the Chart menu, select Options,
gt; gt;gt; click on the Axes tab, and change Category (X) axis to Category.
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt;gt; PeltierTech.com/
gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt; quot;pbquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt;
gt; gt;gt; gt; I'm trying to build an excel stock chart and i don't know how to remove
gt; gt;gt; gt; weekends from it. I don'd have them in the data table...but they appear
gt; gt;gt; gt; in
gt; gt;gt; gt; the chart.
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;