Hi,

Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.

When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!

Hope this makes sense.

Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn this feature off.

Thanks