removal weekend - chart 2007

O

oldLearner57

hi community

i plotted data with weekdays only but when i transferred to chart area, the
chart displayed the weekend days as well.

I am using excel 2007 and like to know how can i remove the 2 weekend
(sat/sun) from the cateogry axis

thanks community for the help render

:)
 
S

ShaneDevenshire

Hi,

Change the x-axis scale form Time-scale to Category, now call Text:
Right click the x-axis on the chart and choose Format Axis
On the Axis Options tab select the Text axis option.

If this helps,
Please click the Yes button
 
Top