COLUMN LINE

From ZCubes Wiki
Jump to navigation Jump to search
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)

Columnline.JPG

GRAPHING MAIN PAGE