How to Create a Column Chart in Excel

A column chart is a type of bar chart in which the bars go up vertically. These charts are commonly used to represent, analyze, and compare large groups of categorical data in a visual form. Most businesses use column charts in presentations and meetings. A simple way to create a column chart is by using MS Excel. You can create a column chart in excel with any data that you have. 

To learn how to create a column chart in Excel, we have put together a basic how-to tutorial. Follow the guide below to learn how to make a column chart in Excel.

How would you like to create your Column Chart?

How to Create a Column Chart in Excel

Step 1 – Launch MS Excel

Launch MS Excel and select a blank workbook.

Step 2 – Enter Data

Enter your data on the sheet. You can either type it all manually or copy and paste it from another file.

enter data

Step 3 – Select Data

Select the data by clicking on it then click on the Insert Tab..

Step 4 – Insert Chart

Click on the vertical graphs called Insert Column Chart in the Charts section of the Insert Tab. Click on the drop-down arrow and select More Column Charts. A pop-up window will appear. Click on the Column in the navigation pane on the left and choose the type of column chart you want. The options include the Stacked Column Chart, Clustered Column, 3-D Column, and more. Once you click on the desired chart type, the column chart in MS Excel will appear on your workbook.

select column chart

Step 5 – Customize your Column Chart Excel

Now edit the column chart according to your needs. Adjust the size of the graph by selecting the chart and then dragging the corners. Click on the section of the chart which you want to edit. You can adjust the chart by formatting text, adding images, and changing colors. You can also change the data anytime, and the column chart will be adjusted automatically. 

customize column chart

Step 6 – Save File

Close the Excel window once you have edited the data. To save the document, click on the File tab. Click on the Save option to save your file. A pop-up window will appear. Please select the desired file location, name your document, and click on the Save option to keep it on your desktop. Our tutorial on how to create a column chart in excel ends here.

How to Create a Column Chart in Edraw Max

Edraw Max Online allows you to use a wide range of tools and templates to create different types of visual content. If you want to make a column chart in MS Excel without any limitation or difficulty, use Edraw Max. Visit https://www.edrawmax.com/online/ to create a column chart excel in just a few simple steps! Follow the steps mentioned below to learn how to create a column chart in MS Excel using Edraw Max templates.

Step 1 – Go to Edraw Max

Open Edraw Max online on your browser and click on Graphs and Charts on the left side of the screen.

open edrawmax

Step 2 – Select Chart

Once you click on Graphs and Charts, different options will appear on the screen. Now select the first option, i.e., Column and click on it. Different Edraw free templates will appear on the screen. Choose the desired template. 

edraw column chart

Step 3 – Open Editor Window

When you click on the template, Edraw Online editor will launch. You can edit and customize your chart in this window. If you do not choose a template, you can also create a chart by clicking on the Chart option in the Insert Tab. 

edraw insert chart option

Step 4 – Enter Data

To enter the data, click on the Data tab on the right side of the screen. An Import option is also available to bring CSV data and adjust each column. 

edraw import data

Step 5 – Customize your Column Chart

Customize your column chart excel with the help of different editing and formatting tools present in Edraw. You can change the shape, size, color, alignment, and all other details according to your preference. Many editing options are available in the navigation pane on the right side of the screen, including layers, style, theme, image, setup, property, and more. You can also use the Insert Tab and the Home tab to add watermark, pictures, QR code, etc.

edraw customize chart

How to Save an Edraw Chart as an Excel File

Edraw Max Online allows export Edraw documents in the file format of MS Excel. Click on File, then Export to select the desired file type. You can save the Edraw column chart as an Excel File and edit using MS Excel. You can also save Edraw documents in Google Drive and Dropbox, which makes it simpler for users to share and save visual content created on Edraw.

Our tutorial on how to make a column chart in Excel and Edraw concludes here.. 

edraw export chart

Related Articles