Stopping Date Autofill in Chart Wizard

[Ripper]

I am trying to make a chart from specific days and Excel keeps putting in the
weekend dates. How do I get Excel to stop helping me?

 

[Robin Hammond]

Ripper,

you need to set the category type to xlCategoryScale.

Assuming objChart is your chart...

objChart.Axes(xlCategory).CategoryType = xlCategoryScale

Robin Hammond
www.enhanceddatasystems.com