How to remove weekends from the chart

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

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

Your solution worked like a charm. Thanks

Cheers
Saran

"Andy Pope" wrote:

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

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