Dates in chart

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
 
A

Andy Pope

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
 
E

Ellie

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping dates on a chart 5
Chart problem with dates 1
How to remove weekends from the chart 2
Charting only the dates shown 1
Show only workdays in chart axis? 4
Dates Incorrect in Chart 5
Chart filling in dates that aren't supposed to be there 7
remove dates from chart 2

Top