Difference between revisions of "COLUMN LINE"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''COLUMN-LINE'''</div> ==='''''Description:'''''=== '''''A clustered column chart displays more than one data series in clustered vertical columns...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''COLUMN-LINE'''</div> | <div style="font-size:30px">'''COLUMN-LINE'''</div> | ||
==='''''Description:'''''=== | ==='''''Description:'''''=== | ||
| − | '''''A | + | '''''A line-column chart combines a line graph and column chart on the same graph.'''''<br> |
| − | ''''' | + | '''''The two charts share an X-axis but each has its own Y-axis.'''''<br> |
| − | + | '''''There are two common uses for a combination chart:'''''<br> | |
| + | '''''1. When we want to display two different data sets together and'''''<br> | ||
| + | '''''2. When we want to display the sets of the same type of data but the ranges vary widely between the two.''''' | ||
*'''''It is a X vs (Y1,[Y2]....) graph.''''' | *'''''It is a X vs (Y1,[Y2]....) graph.''''' | ||
**'''''X-axis represents one set of data. | **'''''X-axis represents one set of data. | ||
| − | **'''''Y-axis can | + | **'''''Y-axis can represents multiple data sets. |
==Example== | ==Example== | ||
Latest revision as of 09:02, 9 June 2020
COLUMN-LINE
Description:
A line-column chart combines a line graph and column chart on the same graph.
The two charts share an X-axis but each has its own Y-axis.
There are two common uses for a combination chart:
1. When we want to display two different data sets together and
2. When we want to display the sets of the same type of data but the ranges vary widely between the two.
- It is a X vs (Y1,[Y2]....) graph.
- X-axis represents one set of data.
- Y-axis can represents 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)
