Wednesday, January 23, 2019

Column Chart

Column charts are used to compare values across categories by using vertical bars.

To create a column chart, execute the following steps.


  • Select the range A1: A7, hold down CTRL and select the range C1: D7.

select-data column chart

  • On the Insert tab, in the Charts group, click the Column symbol.
insert column chart

  • Click Clustered Column.
    click-clustered-column
  • Result: 
    result column chart

Note: only if you have numeric labels, empty cell A1 before you create the column chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically places these numbers on the horizontal (category) axis. After creating the chart, you can enter the text Year into cell A1 if you like.




on
Labels: