removal weekend - chart 2007
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 :) -- oldLearner57 |
removal weekend - chart 2007
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 -- Thanks, Shane Devenshire "oldLearner57" wrote: 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 :) -- oldLearner57 |
All times are GMT +1. The time now is 07:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com