Chart problem with dates

[Janel]

Hi,

I am creating a chart that has week day information only, but when the chart
is formed, the weekends are included. Is there a way to exclude the
weekends? There is no weekend information in the chart data area.

Thank you,
Janel

 

[Andy Pope]

Hi,

In order to exclude dates that do not have data you can set the axis to
be categorical. This will plot a point for each date which will be
equally spaced.

Right click chart and pick Chart Options from the context menu. On the
scale tab set the axis type to category.

Cheers
Andy