Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Bar Chart to line chart excel 2007 | Charts and Charting in Excel | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
Weekend | Excel Worksheet Functions | |||
removal of zero in column chart | Charts and Charting in Excel |