Create Column Chart in Excel
Column chart is the most used chart in Excel. Column charts are very simple. It is a graphical presentation of data in Excel spreadsheet. Column chart display values for one or more categories. Column charts are effective when we have to compare values of many series. Excel offers 7 different types of column charts like Clustered Column, Stacked Column, 100% Stacked Column, 3-D Clustered Column, 3-D Stacked Column, 3-D 100% Stacked Column, 3-D Column.
| Tip: Hovering over each option from the drop down menu, a preview is seen of the highlighted chart in the spreadsheet. |
Let’s see the steps on how you can create Column Chart in Excel:
Step 1: Select the data set. Here we have select A1:C9
Step 2: Go to insert Tab in the Chart group, select Column Chart
Step 3: Click on Clustered column chart & Remove Chart title & Formatting Chart style like remove Grid lines, Legend put on Top and change the background color of chart and change bar color for more appealing
Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.
Follow Excel Superstar
