Plots data in order and joins with lines stacked by category to represent 100%.
Track changes or trends over time.
Stacked Line option is also available.
Data Format
- x-axis: Categories (e.g. years)
- Data must have an order.
- Categories are distributed evenly along the horizontal axis.
- Equal intervals, like months, quarters, or fiscal years, are preferable.
- Chart shows all data points.
- y-axis: Data Series (e.g. net official development assistance received)
- Series are distributed along the vertical axis in percent (%).
- Chart handles multiple series which are stacked to total 100% for all categories.
- Emphasize the contributions to the whole for two or more data series.
- Becomes visually complex as more series are added.
- Chart handles positive and negative values but interpretation can be difficult.
- Lines shown with or without markers.
- Use a data table instead of data labels to limit the complexity of the chart.
| Series 1 | Series 2 | Series 3 | Series 4 | Series 5 | |
|---|---|---|---|---|---|
| Category 1 | # | # | # | # | # |
| Category 2 | # | # | # | # | # |
Try it now!
- Select a country/region from the dropdown list to view net official development assistance received (current US$).
- The chart, title and values adjust to reflect the data for each country or region.
- The top line is with marker; all other lines are without marker.
- This chart was built using data validation lists, named ranges, conditional statements and the IF, IFERROR, MATCH, OFFSET, SUM and SUMIF functions.
Related Line and Area Charts