Dates in chart
 

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

Dates in chart
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ellie" wrote in message
...
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

Dates in chart
 

Thank you so much, Andy. Works great.

Ellie

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ellie" wrote in message
...
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