sorry, i should have been more clear, how do i do it in 07? i've been all
over the ribbon and can't find the chart options that 03 had, and right
clicking doesn't give it to me.

"Andy Pope" wrote:

Hi,

You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can set
the axis type to category.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"sara rovang" <sara wrote in message
...
How do i stop a line graph from automatically adding weekend dates? I
just
want the dates in the data, work days.