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