Focus video player for keyboard shortcuts
We hope you enjoyed this lesson.
Cool lesson, huh? Share it with your friends
About this lesson
Bar Charts are useful for comparing values to each other. This lesson examines features that can be tweaked to optimize their consumption.
Download this lesson’s related exercise files.Bar Charts
29.2 KB Bar Charts - Completed
Working with Bar Charts.
When to use
Bar Charts are useful for comparing values to each other.
- Reminder of Charting Goals
- Every chart should tell a story, quickly and effectively
- Extra chart elements create noise, and get in the way of the story
- It is a best practice to remove as much excess ink (noise) as you can
Creating a Bar chart
- Select your data
- Go to Insert --> Charts -->Bar Charts and select the 2D Bar chart
- Expand the chart so that all rows are readable
- To link a title to a cell, select the chart title, press the equals key, click on a cell and press Enter
- Right click the data series (bars) and choose Format Data Series
- Adjust the Gap width down to make the bars wider
- Select the numbers in the axis
- Click the bar chart icon in the Format Axis task pane
- Expand NUMBER and change the number formats
Re-sort the data
- Select the source data from the original table
- Go to Data --> Sort
- Sort [Your chosen field] --> Smallest to Largest
Hints & tips
- Remove items and elements that you don’t need by selecting them and pressing the Delete key
- A common addition is to right click a series and choose Add Data Labels
- Change font sizes by selecting an element and formatting it from the Home tab
- When removing gridlines, make sure you are selecting the gridlines and not the entire chart!
Lesson notes are only available for subscribers.