Excluding data from a chart

[chowchow123]

Hi

I've drawn a chart based on the data below:

<TABLE style="WIDTH: 293pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=389 border=0 x:str><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=74 height=17 x:fmla="=IF(WEEKDAY(TODAY(),2)<6,TODAY(),IF(WEEKDAY(TODAY(),2)=6,TODAY()+2,IF(WEEKDAY(TODAY(),2)=7,TODAY()+2)))" x:num="39638">09-Jul</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=76 x:fmla="=IF(WEEKDAY(TODAY()+1,2)<6,TODAY()+1,IF(WEEKDAY(TODAY()+1,2)=6,TODAY()+3,IF(WEEKDAY(TODAY()+1,2)=7,TODAY()+3)))" x:num="39639">10-Jul</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=77 x:fmla="=IF(WEEKDAY(TODAY()+2,2)<6,TODAY()+2,IF(WEEKDAY(TODAY()+2,2)=6,TODAY()+4,IF(WEEKDAY(TODAY()+2,2)=7,TODAY()+4)))" x:num="39640">11-Jul</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 64pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=85 x:fmla="=IF(WEEKDAY(TODAY()+3,2)<6,TODAY()+3,IF(WEEKDAY(TODAY()+3,2)=6,TODAY()+5,IF(WEEKDAY(TODAY()+3,2)=7,TODAY()+5)))" x:num="39643">14-Jul</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 58pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=77 x:fmla="=IF(WEEKDAY(TODAY()+4,2)<6,TODAY()+4,IF(WEEKDAY(TODAY()+4,2)=6,TODAY()+6,IF(WEEKDAY(TODAY()+4,2)=7,TODAY()+6)))" x:num="39644">15-Jul</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>1</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>0</TD></TR></TBODY></TABLE>

As you can see it misses saturday and sunday but when the chart is drawn, though there is no data for saturday and sunday - these are still there on the x-axis on the chart- any way to exclude weekends?

Thanks

 

[Andrew Poulsom]

Right click the chart and choose Chart Options. On the Axes tab check Category (rather than Automatic) under Category (X) axis.