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
 

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

Similar Threads

category axis - date 2
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Bizarre chart behaviour when changing axis cross at points 2
2-y axis line chart 4
Find number of weekdays and wekend days given a total number of da 7
Using only dates needed in Excel 2007 chart 1
Excel 2007: continuously update scatter chart from scroll bars 1
Unabe to move data plots on chart in Excel 2007 1

Top