Jul 14, 2016
Let’s say you have the company’s performance information in an Excel spreadsheet. Your manager wants you to chart the data so it is easier to present it in the next meeting. Your company is not working on weekends and the report stores the data for the last 2 weeks starting from 1st August 2016. See the figure below:
When you chart the range B2 to C11, Excel includes Saturdays and Sundays in the chart horizontal axis by default. Since weekends are non-working days, you have no data for those days.
As there is no amount for weekends, the chart does not display bars, but it adds the weekends’ dates to the horizontal chart axis. The chart looks ugly and unprofessional.
Your manager wants those dates hidden from the chart.
If you want Excel to omit the weekends and the missing dates from the chart axis you can change the axis format to a ‘Text Axis’.
To change the chart axis display follow the steps listed below:
- Click the chart to select it
- Right click the horizontal axis. A list with options will display.
- Click the Format Axis option. The Format Axis pane will display on the right hand side of the window.
- Under Axis options, Axis Type, tick the Text axis option
- Close the Format Axis pane
The chart hides the weekend’s dates and makes it look so much better!
How do your Excel skills stack up?
Test NowNext up:
- 5 posts to help you become a better communicator
- SharePoint 2016 social features
- How-To series: Password protect sections in OneNote 2013
- Managing for excellence: An innovative approach to managing performance
- How-to: Give access to a list only in SharePoint 2013
- PowerShell Basics Series – Manipulating strings
- Formula vs. measure in PowerPivot
- PhotoShop in action - Part 1
- Stop whinging; it’s boring!
- Windows Store for Business
Previously
- PowerShell Basics Series – Measuring objects (Part 2)
- Create cascaded drop-downs in Microsoft Access forms
- Working with Styles - Part 2
- What is Continual Service Improvement (CSI)?
- Honesty at work
- Search for a Worksheet Function in Excel
- Providing feedback for user interactions
- Working with Styles - Part 1
- Millennial Musings
- View Types in SharePoint