I am trying to make a chart that tracks progress each week from Monday
to Friday.

i.e. June 5 to June 9, then June 12 - June 16. This goes on the X-axis.

Each time I try and chart the series without the dates it works OK. As
soon as I add the date, Excel automatically fills in the weekend days.

I have looked at every option that I can think of and prefs but can't
get it to just show the dates that I actually want to chart.

Can someone tell me how I can force Excel not to show dates for which
there is no data and there is no labels etc?

Thanks in advance

Using Excel 2004 for Mac.

Chart menu Chart options Axes tab, choose Category (not Time Scale or
Auto) for Category (X) Axis.
/sig
"Nuke" wrote in message
...
I am trying to make a chart that tracks progress each week from Monday
to Friday.

i.e. June 5 to June 9, then June 12 - June 16. This goes on the X-axis.

Each time I try and chart the series without the dates it works OK. As
soon as I add the date, Excel automatically fills in the weekend days.

I have looked at every option that I can think of and prefs but can't
get it to just show the dates that I actually want to chart.

Can someone tell me how I can force Excel not to show dates for which
there is no data and there is no labels etc?

Thanks in advance

Using Excel 2004 for Mac.