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