Excluding weekends from stock chart

I

Isy Taman

I am trying to chart a high-low-close stock chart. The
first field in the data series is the date. Because it is
stock data there are obviously no data points at the
weekends. Excel recognises the field as a date and the x
axis is correctly formatted except that it creates gaps
in the graph every 5 days to represent the weekends. How
can I exclude the weekends since no weekends appear in the
data.

Thank you
 
D

Debra Dalgleish

You can change the x-axis setting:

1. Select the chart
2. Choose Chart>Options
3. Select the Axes tab
4. For Category (x) axis, choose Category, click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XY Charts Excluding Weekends 1
How to remove weekends from the chart 2
Show only workdays in chart axis? 4
Remove weekends from a stock chart 4
XL2007: stock chart- difficulty adding additional series 1
creating a secondary axis from stock chart 1
excluding weekends from date format 2
Excel 2007 Stock market Charts 3

Top