chart with dates on the x-axe

  • Thread starter Thread starter chriske
  • Start date Start date
C

chriske

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
 
Back
Top