Difference between revisions of "CLUSTERED COLUMN"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
*'''''Clustered column chart is a column chart which represents data virtually in vertical columns in series.''''' | *'''''Clustered column chart is a column chart which represents data virtually in vertical columns in series.''''' | ||
*'''''It is a X vs (Y1,[Y2]....) graph.''''' | *'''''It is a X vs (Y1,[Y2]....) graph.''''' | ||
| − | *X-axis has one set of data. | + | **'''''X-axis has one set of data. |
| − | *Y-axis can represent single or multiple data sets. | + | **'''''Y-axis can represent single or multiple data sets. |
==Example== | ==Example== | ||
Revision as of 07:29, 3 June 2020
CLUSTERED COLUMN
Description:
A clustered column chart displays more than one data series in clustered vertical columns.
Each data series shares the same axis labels, so vertical bars are grouped by category.
- Clustered column chart is a column chart which represents data virtually in vertical columns in series.
- It is a X vs (Y1,[Y2]....) graph.
- X-axis has one set of data.
- Y-axis can represent single or multiple data sets.
Example
| A | B | C | |
| 1 | Row | Year1 | Year2 |
| 2 | Row1 | 4 | 3 |
| 3 | Row2 | 7 | 8 |
| 4 | Row3 | 12 | 23 |
| 5 | Row4 | 17 | 18 |
| 6 | Row5 | 36 | 67 |
| 7 | Row6 | 34 | 56 |
CLUSTEREDCOLUMN(A1:C7)
