Hi, I have a line chart where the x axis is a date. The source values in the corresponding table include date in the first column with the data point value in the second column. There are only dates and corresponding values for the weekday dates. Although no weekend dates are shown in the table, the x axis displays the weekend dates and the line stretches across the weekend dates to connect the Friday's data point to the Monday data point.
I can not figure out how to eliminate these dates so the axis shows the Friday date immediately follwed by the Monday date just as it is in the table.
thanks for your help.
I can not figure out how to eliminate these dates so the axis shows the Friday date immediately follwed by the Monday date just as it is in the table.
thanks for your help.