Hi,

You would need to set the axis to Category rather than Time Series or
Automatic.
Right click chart Chart Options Axes.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tracey" wrote in message
...
How do I eliminate dates in a timeline spreadsheet?