How to Create a Column Chart in Excel
To draw a column chart in Excel, you first need to have a table, whose values are required for displaying through the chart. So is our first step.
Step 1: Let’s have a scorecard of the previous match as our table and try to visualize it.
Let’s consider this as our desired table. Here the scorecard of India vs West Indies 3rd ODI 2022 is presented.
Step 2: Now, we have to represent this table in a form of a column chart. Then go to the “Insert” menu and select the desired chart or use all chart options (highlighted in sky color). If working on Excel 2013, then charts are under the design tab.
Step 3: You can find different table options there or can manually go see all charts which is the down arrow type button and go to all charts.
Step 4: Select the desired chart and click on OK. The chart will appear in the Excel sheet. You can customize the Excel as per your requirement. We have used Stacked Column as it is best suited for our data. You may use Clustered Column, Stacked Column, 100% Stacked Column, 3D Clustered Column, 3D Stacked Column, 3D 100% Stacked Column, and 3-D Column charts under the column chart option.
Our created charts look like this now:-
How to Make a Column Chart in Excel
Column Charts provide advanced options that are not available with some other chart types such as trendlines and adding a secondary axis. This tutorial will walk you through the step-by-step process of creating a column chart in Microsoft Excel.
Column charts are used for making comparisons over time or illustrating changes. In the column chart, the horizontal bar shows categories, while the vertical bar shows values.
Contact Us