Using only dates needed in Excel 2007 chart
 

I'm trying to Chart data from a table and when I create a chart it adds in
the days between mine. I only want working days. This is in Excel 2007.

Using only dates needed in Excel 2007 chart
 

Change the x-axis to catgegory, not Time Scale. (Chart options, axis)
This will display only the data you've given XL.

--
Best Regards,

Luke M
"HFST04" wrote in message
...
I'm trying to Chart data from a table and when I create a chart it adds in
the days between mine. I only want working days. This is in Excel 2007.