Desktop

Ask something
Discussion Locked

Stop Excel showing weekends on chart

0 helpful
3 replies

by bnk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a spreadsheet where I entered data against three dates. The dates fell on Thursday, Friday, and Monday. The chart shows the data, but in addition to the the three dates entered the dates for Saturday and Sunday display with no data.
How do Iget the chart to skip displaying weekend dates for Saturday and Sunday that I did not enter.

3 replies

by dklippert

Select the Chart. On the Menu go to Chart>Chart Options. On the Axes tab change the Primary axis from Automatic (or Time-Scale) to Category

This discussion is closed to new replies.