When you convert your data into a chart, Excel tries to make sense of the data it is charting. These dates are not in the original data and he cannot seem to get rid of them so that only the data in the table is shown in the chart.īelieve it or not, this behavior is by design. (The data contains no entries for weekends.) When Scott graphs the data using the dates as the horizontal axis, Excel inserts the weekend dates with no data points. The data is entered by date which only reflects weekdays.
Scott has a set of data by date that is used for a graph.
