A combo chart is a chart that combines two or more types of standard charts. There are a few steps to follow to create a combo chart:
- Selecting a range A1: B5.
- On the Advanced tab Insert (Inser) in command group Diagrams (Charts) click Timetable > Graph with markers (Line > Line with Markers). As a result, a chart will be built with two data series (red and blue):
- Select a chart. A group of contextual tabs will appear Working with charts (Chart Tools).
- Go to the tab Layout (Layout), in section signatures (Labels) find the button Legend (Legend) and click on it. From the dropdown list select Add legend below (Show legend at Bottom).
- Next, right-click on the red data row and select Data series format (Format Data Series).
- Turn on the option Build a row > Minor Axis (Plot Series On > Secondary Axis).
- Close the dialog box, leaving the red data row selected.
- Go to the tab Insert (Insert) and in a group Diagrams (Charts) press the button bar chart > Histogram with grouping (Column > Clustered Column).
As a result, we get a combined chart:
