View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Saran Saran is offline
external usenet poster
 
Posts: 18
Default 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