How to Add a Line to an Excel Stacked Chart

1. Right-click on your chart, and click the 'Select Data' option.
2. Click 'Add' in the 'Select Data Series' dialog box under 'Legend Entries.'
3. 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.
4. Click once on your new data series in the chart, regardless of the format the series defaulted to.
5. Right-click on your highlighted data series, and click 'Change Series Chart Type.'
6. Select the 'Line' option in the dialog box, and click 'OK.'