Hi

For such interval, your times are probably years. When yes, then you can
simply use numeric year values instead of dates.

To convert a date to year number, use the formula (with date p.e. in cell
A2)
=YEAR(A2)
and format as General

To conert a tate to yer number BP, use the formula
=YEAR(A2)-YEAR(TODAY())
and format as General
etc.

Create your diagram as XY chart with years as X-axis values

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Folke Günther" <Folke wrote in message
...
I want to make a diagram with a time series that goes from -1000000 to
present. Hov can I accomplish that, since for MS the time starts at 1900?
Moreover, I want to display the dates as BP (before present) How could
that
be done?
FG