Chart problem with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top