How to Add a Line to an Excel Stacked Chart
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.
Right-click on your chart, and click the "Select Data" option.
Click "Add" in the "Select Data Series" dialog box under "Legend Entries."
Enter the data range you want to use for the line graph in the "Edit Series" dialog box under "Series values." Click "OK," and close out of the dialog boxes.
Click once on your new data series in the chart, regardless of the format the series defaulted to.
Right-click on your highlighted data series, and click "Change Series Chart Type."
Select the "Line" option in the dialog box, and click "OK."