If you set the axis to 1996 to 2007 then the actual values are

Min = 35065
Max = 39083

If your chart data is not within that range it will not appear.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"adag59" wrote in message
...
min 1996 max 2007 values 1/years

"Andy Pope" wrote:

Hi,

What values are you setting the axis to?
What are the min/max values of your data?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"adag59" wrote in message
...
I am making a simple bar graph. every time I go to change the x axis
from
numbers to year dates, the bars disappear???