Resembles a topographic map with colors and patterns representing similar values.
Useful for spotting optimum combinations between 2 sets of data.
3D, Wireframe 3D, Contour and Wireframe Contour versions exist.
Data Format
- x-axis: Categories (e.g. countries or years)
- Categories are distributed evenly along either of the horizontal axes (X or Z).
- Categories can be numeric.
- y-axis: Data Series (e.g. tax revenue as % of GDP)
- Series are shown on the vertical axis.
| Series 1 | Series 2 | Series 3 | Series 4 | |
|---|---|---|---|---|
| Category 1 | # | # | # | # |
| Category 2 | # | # | # | # |
| Category 3 | # | # | # | # |
| Category 4 | # | # | # | # |
| Category 5 | # | # | # | # |
Try it now!
- Select a region using the dropdown list to view tax revenue as a percentage of GDP for 5 random countries.
- Note how the chart and title adjust to reflect the different values.
- This chart was built using data validation lists, named ranges, conditional statements and the IF, MATCH, OFFSET, RANDARRAY, SEQUENCE, SORTBY, TEXT and VLOOKUP functions.
Related Waterfall, Funnel, Stock, Surface or Radar Charts
- Funnel
- Radar
- Stock (High, Low, Close)
- Stock (Open, High, Low, Close)
- Stock (Volume, High, Low, Close)
- Stock (Volume, Open, High, Low, Close)
- Waterfall