G Guest Feb 24, 2005 #1 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?
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?
R Robin Hammond Feb 25, 2005 #2 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, you need to set the category type to xlCategoryScale. Assuming objChart is your chart... objChart.Axes(xlCategory).CategoryType = xlCategoryScale Robin Hammond www.enhanceddatasystems.com