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

"Ripper" wrote in message
...
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?

--
Thanks As Always
Rip