How do I get non-sequential dates on X-axis
 

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.

How do I get non-sequential dates on X-axis
 

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.