chart with dates on the x-axe

how can you change the x-axe into a text x-as when the data are dates ? on specific dates a want to show a specific value. When I want to create e.g. a line-type chart, the values are ok, but the x-axe with the dates becomes a time-ax in stead of showing the real dates from the data.
Is there a way to change the dates into text, without making it explicit text (with a ') because I want to use them also for calculating things.

???

Hi,

Right click the chart and pick Chart Options. On the axis tab is the
option to specify Category axis rather than Automatic or Time Series.

Cheers
Andy

chriske wrote:
> how can you change the x-axe into a text x-as when the data are dates ?
> on specific dates a want to show a specific value. When I want to
> create e.g. a line-type chart, the values are ok, but the x-axe with
> the dates becomes a time-ax in stead of showing the real dates from the
> data.
> Is there a way to change the dates into text, without making it
> explicit text (with a ') because I want to use them also for
> calculating things.
>
> ???
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info