Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

How to Create Column Chart in Excel

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

To create a column chart, execute the following steps.

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

2. On the Insert tab, in the Charts group, click the Column symbol.

3. Click Clustered Column.



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.

Leave a Reply

Your email address will not be published. Required fields are marked *