Thread: stock chart -- how to include only trading days

Trying to do a simple high-low-close stock chart. I have these three items
listed for each trading day in columns on the worksheet. Also have
corresponding trading dates in a column. The chart insists on showing on
the X axis all dates, including non-trading dates. On the body of the chart
there are blanks between data points, corresponding to the non-trading
dates. How can I get the X axis to omit the non-trading dates?

Thanks in advance.

Jordan Burkart

Excel saw the dates and assumed you wanted a time scale axis.

Choose Chart Options from the Chart menu, click on the Axes tab, and
check Category for Category (X) Axis.

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


Jordan Burkart wrote:

> Trying to do a simple high-low-close stock chart. I have these three items
> listed for each trading day in columns on the worksheet. Also have
> corresponding trading dates in a column. The chart insists on showing on
> the X axis all dates, including non-trading dates. On the body of the chart
> there are blanks between data points, corresponding to the non-trading
> dates. How can I get the X axis to omit the non-trading dates?
>
> Thanks in advance.
>
> Jordan Burkart
>
>

Jon,

Many thanks. Your suggestion did the trick. Never would have figured it
out on my own.

Jordan

"Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
news:Om7SKGhmFHA.2852@TK2MSFTNGP15.phx.gbl...
> Excel saw the dates and assumed you wanted a time scale axis.
>
> Choose Chart Options from the Chart menu, click on the Axes tab, and check
> Category for Category (X) Axis.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> Jordan Burkart wrote:
>
>> Trying to do a simple high-low-close stock chart. I have these three
>> items listed for each trading day in columns on the worksheet. Also have
>> corresponding trading dates in a column. The chart insists on showing on
>> the X axis all dates, including non-trading dates. On the body of the
>> chart there are blanks between data points, corresponding to the
>> non-trading dates. How can I get the X axis to omit the non-trading
>> dates?
>>
>> Thanks in advance.
>>
>> Jordan Burkart