stock chart -- how to include only trading days

  • Thread starter Thread starter Jordan Burkart
  • Start date Start date
J

Jordan Burkart

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/
_______
 
Jon,

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

Jordan
 
Back
Top