How to remove weekends from the chart

  • Thread starter Thread starter Saran
  • Start date Start date
S

Saran

I am trying to create a very simple chart with the "Dates" on the x-axis and
"Data" on the y-axis.

Since i do not have any data on the weekends i do not have that in the list
from where the chart is being made, however the chart always shows up the
weekends as well, with the entry being blank. Data as below:

date data
2-Feb-09 5
3-Feb-09 7
4-Feb-09 19
5-Feb-09 12
6-Feb-09 14
9-Feb-09 18
10-Feb-09 10
11-Feb-09 11
12-Feb-09 4
13-Feb-09 5

I want to know if there is a way to remove the weekends with the blank data
from the Charts
 
Hi,

You need to plot the axis as category rather than Time series.
xl2003 - Chart Options > Axes > Category
xl2007 - Format axis > Axis Options > Text Axis

Cheers
Andy
 
Back
Top