Excel Chart Adding Dates

[MFeightner]

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????

 

[MFeightner]

I figured it out...
Youc an change the x-axis type to Text rather than automatically select.