✦Template Printable Ideas Insights

Mastering Excel: Create Simple Column Charts in Minutes

By

Excel is a powerful tool that makes data organization and visual representation a breeze. One of its many strengths lies in its charting capabilities, which allow users to convert vast amounts of data into easily understandable and presentable visuals. One of the simplest yet most effective types of charts is the column chart. Here's a straightforward guide on how to create one.

Before we dive into the specifics, ensure you have Excel open and a spreadsheet with numeric data ready. For this example, let's assume we have sales data for four different regions in columns A, B, C, and D, with headers 'Central', 'East', 'North', and 'South' in row 1.

Create a Column Chart

Once you've prepared your data, follow these steps to generate your first column chart:

Column Chart in Excel
Column Chart in Excel
Download 61 Excel Charts Examples to Master Today!
Download 61 Excel Charts Examples to Master Today!
Create a Stacked Column Chart with Total in Microsoft Excel
Create a Stacked Column Chart with Total in Microsoft Excel

Select Your Data

Start by highlighting the data you want to chart. For our example, that's typically the sales figures, not the headers. But Excel has a trick up its sleeve that lets you include the headers in your chart. To do this, select the entire range of data, including the header row, like this: A1:D2 (if your data starts from A1 and ends at D2).

Once selected, click on the 'Insert' tab in the ribbon, then click on the 'Column' icon in the ' Charts' group. Excel will insert a basic column chart, but we can customize it further.

How to create a column chart with background image in Excel ? » Chandoo.org - Learn Excel, Power BI & Charting Online
How to create a column chart with background image in Excel ? » Chandoo.org - Learn Excel, Power BI & Charting Online
3D Infographic Cylinder Column Chart in Excel 2016
3D Infographic Cylinder Column Chart in Excel 2016
How to Use Columns Formula in Excel
How to Use Columns Formula in Excel

Customize Your Chart

Excel has many types of column charts to choose from. To switch between them, click on the chart to activate it, then click on the 'Design' tab in the ribbon. Here, you can choose from different 'Varieties' of column charts by clicking on the appropriate icon.

Let's say you choose a 'Clustered Column' chart, which is a good choice for comparing data across categories. Now, you might want to add a title and labels to your chart. To do this, click on the 'Add Chart Element' dropdown in the 'Design' tab, then choose 'Chart Title' and 'Axis Titles' as needed. Enter the desired text in the pop-up boxes and click OK.

Format Your Chart

Now that you've customized your chart, it's time to give it some polish. Click on the chart to activate it, then click on the 'Format' tab in the ribbon. Here, you can change the color scheme, add data labels, and more.

How to Create a Simple Column Chart by Category in Excel?
How to Create a Simple Column Chart by Category in Excel?
How to Make a Chart in Excel
How to Make a Chart in Excel
Create a Column Chart with Multiple Targets and Highlights in Excel
Create a Column Chart with Multiple Targets and Highlights in Excel
Create a Column Chart to Display Variance with Different Colors
Create a Column Chart to Display Variance with Different Colors
Create a Progress Tracker Using Stacked Column Chart in Excel
Create a Progress Tracker Using Stacked Column Chart in Excel
5 simple rules for making awesome column charts » Chandoo.org - Learn Excel, Power BI & Charting Online
5 simple rules for making awesome column charts » Chandoo.org - Learn Excel, Power BI & Charting Online

For instance, to add data labels, click on the 'Add Data Labels' icon in the 'Labels' group. You can then adjust their position and appearance using the 'Format Selection' pane on the right side of the screen.

Update Your Chart Automatically

What if you add more data to your spreadsheet? Don't worry, Excel can update your chart automatically. To enable this, click on the chart, then click in the 'Format' tab, then under 'Current Selection', click on 'Selection Pane'. In the 'Selection Pane' pane that appears, find your chart and check the box next to 'Linked' to ensure your chart updates automatically when you add or remove data.

Export Your Chart

Once you're satisfied with your chart, you might want to export it as an image file. To do this, click on the chart, then click on the 'Design' tab, then click on the arrow next to 'Export' in the 'Export' group. Choose the file type you want (e.g., PNG, JPEG), then click on 'Export'. Choose a location, enter a file name, and click 'Save'.

How to merge and combine Excel spreadsheets into one
How to merge and combine Excel spreadsheets into one
How to Show Percentages in Stacked Bar and Column Charts in Excel
How to Show Percentages in Stacked Bar and Column Charts in Excel
an info sheet showing how to use excel chart
an info sheet showing how to use excel chart

Creating a simple column chart in Excel might seem daunting at first, but with a little practice, it becomes second nature. The key is to experiment with Excel's many chart types and formatting options to find the best fit for your data. Happy charting!