Dates in chart

  • Thread starter Thread starter Ellie
  • Start date Start date
E

Ellie

I have a chart that has data for Monday-Friday only of each week for 12
weeks. The dates are based upon a formula, so alternate every week showing a
rolling 12 week chart. Unfortunately, the chart is showing 5 days with 2
days for the weekend being blank as there is never data at the weekends and
so far attempts to rid the weekends, which are not in the original data at
all, have proved futile.

Can anyone suggest how to rid Saturday and Sunday from the chart?

All help appreciated.

Ellie
 
Hi,

You need to set the axis to be category rather than date.
Right click chart and pick Chart Options. On the Axis tab check the Category
option for the axis.

Cheers
Andy
 
Thank you so much, Andy. Works great.

Ellie

Andy Pope said:
Hi,

You need to set the axis to be category rather than date.
Right click chart and pick Chart Options. On the Axis tab check the Category
option for the axis.

Cheers
Andy
Click to expand...
 
Back
Top