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.

???


--
chriske
------------------------------------------------------------------------
chriske's Profile: http://www.excelforum.com/member.php...o&userid=27506
View this thread: http://www.excelforum.com/showthread...hreadid=470202

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