Column Chart Essentials: Simplifying for Impact
Download
π Design
- Insert a clustered column chart.
- Add data labels.
- Remove y axis.
- Condense repeating labels in the x axis by deleting every other occurrence in the source data.
- Remove gridlines.
- Select the columns and, in Series Options, reduce the Gap Width to make the columns wider.
- Edit the title to get your message across.
- Change series fill color to light grey.
- Manually change the color of the data point(s) you want to highlight β click once to select the series, click twice to select a single data point. Use a dark blue fill color.
- Manually change the font properties of the data label you want to highlight (make it bolder). Click twice to select a single data label.
πΈοΈYou can't select and edit a single data label in Excel for the Web. Learn about other limitations of Excel Online here.
5 comments