Difference between revisions of "STACKED COLUMN"
Jump to navigation
Jump to search
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''STACKED COLUMN'''</div> | <div style="font-size:30px">'''STACKED COLUMN'''</div> | ||
==='''''Description:'''''=== | ==='''''Description:'''''=== | ||
| − | '''''A stacked column chart is a basic | + | '''''A stacked column chart is a basic chart type to allow part-to-whole comparisons over time, or across categories.<br> |
'''''In a stacked column chart, data series are stacked one on top of the other in vertical columns.'''''<br> | '''''In a stacked column chart, data series are stacked one on top of the other in vertical columns.'''''<br> | ||
| + | *'''''Stacked column chart is a column chart where multiple series of the data representation of various categories are stacked over each other.''''' | ||
| + | *'''''It is a X vs (Y1,[Y2]....) graph.''''' | ||
| + | **'''''X-axis represents one set of data. | ||
| + | **'''''Y-axis can represent single or multiple data sets. | ||
==Example== | ==Example== | ||
{| class="wikitable" style="font-size:14px" | {| class="wikitable" style="font-size:14px" | ||
|- | |- | ||
| − | | || '''A''' || '''B''' | + | | || '''A''' || '''B''' ||'''C''' |
|- | |- | ||
| − | | 1|| '''Row''' || ''' | + | | 1|| '''Row''' || '''Year1''' || '''Year2''' |
|- | |- | ||
| − | | 2 || Row1 || 4 | + | | 2 || Row1 || 4 || 3 |
|- | |- | ||
| − | | 3 || Row2 || 7 | + | | 3 || Row2 || 7 || 8 |
|- | |- | ||
| − | | 4 || Row3 || 12 | + | | 4 || Row3 || 12 || 23 |
|- | |- | ||
| − | | 5 || Row4 || 17 | + | | 5 || Row4 || 17 || 18 |
|- | |- | ||
| − | | 6 || Row5 || 36 | + | | 6 || Row5 || 36 || 67 |
|- | |- | ||
| − | | 7 || Row6 || 34 | + | | 7 || Row6 || 34 || 56 |
|} | |} | ||
| − | '''STACKEDCOLUMN(A1: | + | '''STACKEDCOLUMN(A1:C7)'''<br><br/> |
| − | [[File:Columnstacked.JPG]] | + | [[File:Columnstacked.JPG]]<br><br/> |
| + | [[GRAPHING|'''''GRAPHING MAIN PAGE''''']] | ||
Latest revision as of 07:31, 3 June 2020
STACKED COLUMN
Description:
A stacked column chart is a basic chart type to allow part-to-whole comparisons over time, or across categories.
In a stacked column chart, data series are stacked one on top of the other in vertical columns.
- Stacked column chart is a column chart where multiple series of the data representation of various categories are stacked over each other.
- It is a X vs (Y1,[Y2]....) graph.
- X-axis represents 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 |
STACKEDCOLUMN(A1:C7)
GRAPHING MAIN PAGE