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:
Other People Are Reading
Right-click on your chart, and click the "Select Data" option.
Click "Add" in the "Select Data Series" dialogue box under "Legend Entries."
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.
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 dialogue box, and click "OK."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for