x-axis, different names other than values

[akj375]

I'd like to have the x-axis values as displayed on the chart be different than the actual values plotted on the graph. Specifically, my actual x-axis values are date/time values so they're huge mother labels like "October 12, 2009 13:52:27". I absolutely don't want these as my x-axis increment values. Instead I'd like to have the x-axis increment values enumerated as 1, 2, 3... values, while actually plotting the true x-values on the chart itself. Is there a way to do this in Excel 2007. Thanks - AJ.

[pike]

Have a look here

http://www.appspro.com/Utilities/ChartLabeler.htm

Its one of Andy Pope favorites