How to remove weekends from the chart

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top