100% Stacked Line Charts
Excel 100% Stacked Line Charts
100% Stacked Line charts display the percentage of each trend’s contribution to the data.
Scaling the lines to make the total 100% is how this is accomplished.
100% Stacked Line charts are utilized when there is data that can be arranged from low to high.
When you have multiple data columns that add up to the overall trend, you use the charts.
Note: Ordinal data are those that may be arranged in a hierarchy, such as numerical values or letter grades ranging from A to F. Ordinal data is covered in more detail at Statistics – Measurement Levels.
Example
Let’s examine the cumulative average stats for all Pokemon generations.
To keep up, copy the values:
Note: The information is rounded to one decimal place.
- Choose the labels and data range A1:D7.
Note: To access this menu, expand the ribbon.
2. Select 100% Stacked Line (
) from the drop-down menu by clicking on the Insert menu, then the Line menu (
).
You should get the chart below:
The graph provides a visual summary of the typical Pokemon stats between generations.
The average HP’s contribution to the total is indicated by the blue line. Lastly, the gray line displays the total of all the data scaled to 100%. The orange line displays the average Attack’s contribution to the total.
This graph demonstrates that, in comparison to previous generations, HP makes a larger total contribution in the second generation.
100% Stacked Line with Markers
Data points with markers on a 100% stacked line chart are highlighted by a 100% stacked line with markers.
Example
Let’s examine the cumulative average stats for all Pokemon generations.
To keep up, copy the values:
Note: There is one decimal place in this data.
- Choose the labels and data range A1:D7.
Note: To access this menu, expand the ribbon.
2. Click the Insert menu, then select 100% Stacked Line with Markers (
) from the drop-down menu by clicking the Line menu ().
You should get the chart below:
The graph provides a visual summary of the typical Pokemon stats between generations.
The average HP’s contribution to the total is indicated by the blue line. The average Attack’s contribution to the total is indicated by the orange line, while the total of all the metrics scaled to 100% is shown by the gray line.
This graph demonstrates that, in comparison to previous generations, HP makes a larger total contribution in the second generation.
