when I try to put in the data range again to the chart already opened, it say
the data range is to complexed to display. we are only talking about 12
cells/12 bars

"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???