Exclude Weekend from Graph

[Dana]

I have a graph associated with a worksheet. This contains several months
worth of data. When I go to the graph and edit the period that I want to
show, it adds black spaces on the graph for weekends. The weekends did not
show before, so I am thorough confused.

 

[Bob Greenblatt]

I have a graph associated with a worksheet. This contains several months
worth of data. When I go to the graph and edit the period that I want to
show, it adds black spaces on the graph for weekends. The weekends did not
show before, so I am thorough confused.

Try hiding the rows (or columns) that contain the weekend data. If the
weekends truly do not contain any data, try supplying =NA() for the values.

 

[Bill W]

I have a graph associated with a worksheet. This contains several months
worth of data. When I go to the graph and edit the period that I want to
show, it adds black spaces on the graph for weekends. The weekends did not
show before, so I am thorough confused.

I just plugged 7 months of data, with no lines for weekend days. I
found that the display of weekends depended on the Chart menu --> Chart
Options:
On the Axes tab - Category X Axes:
Automatic & Time-Scale will insert the weekend blanks
Category will remove the weekends (which don't exist in the data set
anyway)

Maybe this is your solution, maybe not. good luck