Thread: Dates in chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ellie Ellie is offline
external usenet poster
 
Posts: 37
Default 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