How to Add a Line to an Excel Stacked Chart

Written by anna rose
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Add a Line to an Excel Stacked Chart
You can use more than one chart type in the same graph to display your data. (graph bars image by Tomislav from

Excel charts allow you to display data in many different formats. Lines, bars, pie pieces, two-dimensional, three-dimensional, stacked bars and different axes are some of your many options. Stacked bar charts show portions of wholes along an axis, such as inventory each month where the sections of the stacked bars represent what type of products make up that inventory. If you want to compare these bars to a maximum, minimum or goal line, it is simple to add a line chart to the same graph as your stacked bar chart.

Skill level:


  1. 1

    Right-click on your chart, and click the "Select Data" option.

  2. 2

    Click "Add" in the "Select Data Series" dialogue box under "Legend Entries."

  3. 3

    Enter the data range you want to use for the line graph in the "Edit Series" dialogue box under "Series values." Click "OK," and close out of the dialogue boxes.

  4. 4

    Click once on your new data series in the chart, regardless of the format the series defaulted to.

  5. 5

    Right-click on your highlighted data series, and click "Change Series Chart Type."

  6. 6

    Select the "Line" option in the dialogue box, and click "OK."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.