Column Chart is used to compare values across different categories. This type of chart is plotted using vertical bars. It is one of the good ways to show change over time. This is very easy to compare the column lengths. It is used to plot both nominal (values are classified) and ordinal (values are classified and ordered) data. In this guide, we are going to Create a Column Chart in Excel Office 365.
Create a Column Chart:
Let’s see the steps to create a column chart in Excel.
- Open the workbook where you want to create the bar chart.
- Then, select the data range that you want to chart based on.
- On the Insert tab, select the Bar Charts in the Charts section.
- Then, you need to click the 2-D column to create a chart.
- Finally, you will get the chart based on your data as shown in the below screenshot.
Pros & Cons Column Chart:
Pros:
- It is easy to read.
- Simple and versatile.
- Easy to add data labels at the end of the bars.
Cons:
- It becomes cluttered with too many categories.
- Clustered Column charts are difficult to understand.
Closure:
In this guide, you can quickly understand the steps to Create a Column Chart in Excel Office 365. Kindly, give your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!
Top comments (0)