VBA Charting Dates on X-axis

[kajohnson9]

In excel 2010 vba code, I have a column of date data excluding Saturdays and Sundays (only 5 days a week). When I use VBA to plot the data, the Saturday and Sunday dates are included. Is there some flag I need to set to take my data exactly (no weekends)?

Thanks

 

[GlennUK]

Make the X axis scale as text ( i.e. Categories only ), instead of times.

ActiveChart.Axes(xlCategory).CategoryType = xlCategoryScale