Jon,

I started the sheet with the number of vehicles per year listed across the
sheet starting at A1 through AD1, each cell being a year starting with 1978
to 2008. I then clicked on the chart wizzard and selected line chart.I
forwarded through the set up instructions and the chart appeared with the
data line showing the vehicle numbers. I then changed the Value y scale to
reflect vehicle numbers 0 to 700. I then changed the Category x scale to date
scale and entered what I believe is the proper information for dates in
Format axis, Scale.

Minimun set at 1/1/1978
Maximun at 1/1/2008
Base set at year
Major set at 1 year
Minor set at 1 year
Value y axis crosses at 1/1/1978
Value axis crosses between dates checked

Since I only need a year shown I selected yyyy off of the custom option.
After doing this and applying, all of the years show up but the data line
with vehicle numbers is gone. If I hit the undo arrow I return to the data
line being there but the dates have returned to the default dates orginally
given 1/1/1900.

Thanks

Bullywooly


"Jon Peltier" wrote:

Describe how the data is lost. Is the date information provided as true
dates, and is the category axis set up as a date-scale axis?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bullywooly" wrote in message
...
I am trying to prepare a chart that shows total number of vehicles per year
for a period of 30 years. I am able to create the line chart and can
change
every thing on the value and category scales but when I change the date
information on the category scale and apply it I lose all the data. I have
the date infomation correct but no data or I have data and no date. Any
help
or sugestions?