Plots data in order and joins with a 3D line.
Track changes or trends over time.
2D option is also available.
Data Format
- x-axis: Categories (e.g. quarters)
- Data must have an order.
- Categories are distributed evenly along the horizontal axis.
- Equal intervals, like months, quarters, or fiscal years, are preferable.
- Chart handles multiple categories but can be more difficult to read than 2D version.
- Chart shows all data points.
- Chart does not support secondary axis.
- y-axis: Data Series (e.g. quarterly revenues)
- Series are distributed evenly along the vertical axis.
- Can be difficult to read if lines overlap.
- Can handle positive and negative values.
- Gaps in data are not shown.
- Difficult to read data labels. A data table beneath the chart is optional.
- z-axis: Depth
- 3D Line chart also has a depth axis, unlike a 2D Line chart.
- Floors and walls can be formatted.
| Series 1 | Series 2 | Series 3 | Series 4 | Series 5 | |
|---|---|---|---|---|---|
| Category 1 | # | # | # | # | # |
| Category 2 | # | # | # | # | # |
Try it now!
- Select a FAANG stock from the dropdown list to view quarterly revenue data.
- Note how the chart and title adjust to reflect the different data values for each company.
- This chart was built using data validation lists, named ranges, conditional statements and the MATCH and OFFSET functions.
Related Line and Area Charts