Add a Line to a Stacked Chart

The best way to present our data is always visually. In Excel, there are many ways to do this, and the most famous and useful is with charts. There are many little neat tricks that can help you out in creating the best representation possible.

In the example below, we will show how you can add a line to a particular kind of chart- a Stacked Chart.

Add a Line to an Excel Stacked Chart

For the example, we will use the list of NBA players and their points from one game. We will also add the average number of points for all players, in order to create a line in our chart:


Description automatically generated

To create a Stacked Chart, we will select the data in columns A and B, and then will go to Insert >> Charts and then find this chart type:

Chart, waterfall chart

Description automatically generated

The picture above shows a preview of a chart that will be created when we choose a chart.

To add a line in this chart, we will right-click on it, and then go to Select Data:


Description automatically generated

In the window that appears, we will click Add button under Legend Entries (Series):

Graphical user interface, text, application

Description automatically generated

In the Edit Series window that appears, we will choose cell C1 for Series name (Average points), and under Series values, we will choose the data from column C (basically the same numbers for average points for all players).

Graphical user interface, application

Description automatically generated

When we click OK twice, this is the chart we end up with:

Chart, bar chart

Description automatically generated

Then we need to right-click on the chart again and choose the Change Chart Type option:

Chart, bar chart, waterfall chart

Description automatically generated

In that window, we need to go and choose the last option- Combo chart, and we will choose a Line chart as a chart type for Average points:

Graphical user interface, application, Word

Description automatically generated

As seen in the preview, we will get the line in our Stacked Chart.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.