About this lesson
Combination charts open a whole new world of charting. In this lesson we combine column and line charts together to make a compelling chart.
Download this lesson’s related exercise files.Combination Charts - Column & Line.xlsx
49.1 KB Combination Charts - Column & Line - Completed.xlsx
Combination Charts - Column And Line
Combining column and lines charts into a single chart.
When to use
When you want to graph multiple series and want to show them differently than just lines.
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 the Combination Chart
- Select your data
- Go to Insert --> Charts -->Line Charts and select the 2D Line Chart
- Right click the line you wish to see as a Column --> Change Series Chart Type
- Change the series chart type for each series you wish to change
- 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
- Other modifications can be made as with any normal chart
Hints & tips
- Remove items and elements that you don't need by selecting them and pressing the Delete key
- 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
- When adding data labels to the columns, you may wish to force them Inside Base to avoid showing them with your lines
- Adding markers to the lines is a great way to show how they compare to the column values
Lesson notes are only available for subscribers.