I have vba to create a chart from a pivot table, which by the way works fine. Except, the data points on based on a date and excel automatically adds dates in between for any dates that did not have data.
Is there a way to shut this auto-fill code off????