How to Create a Bar Chart in Excel

WikiHow will show you how to present data in Microsoft Excel more eye-catching and attractive with bar charts.

Add data

How to Create a Bar Chart in Excel Picture 1How to Create a Bar Chart in Excel Picture 1

Open Microsoft Excel. Microsoft Excel has an icon similar to a white "E" on a green background.

If you want to create a graph from existing data, double-click the Excel document containing the data to open it and proceed to the next step.

How to Create a Bar Chart in Excel Picture 2How to Create a Bar Chart in Excel Picture 2

Click the Blank workbook button (for a normal computer) or click the Excel Workbook button (for a Mac). Located at the top left of the window.

How to Create a Bar Chart in Excel Picture 3How to Create a Bar Chart in Excel Picture 3

Add labels to the X and Y axes of the graph. To do this, click cell A1 (X axis) and type a label, then do the same for cell B1 (Y axis).

For example, a chart of temperatures over a week would have a "Days" cell in cell A1 and a "Temperature" cell in cell B1 .

How to Create a Bar Chart in Excel Picture 4How to Create a Bar Chart in Excel Picture 4

Enter data for the X axis and Y axis of the graph. Enter a number or a word in column A or B along the X or Y axis, respectively.

For example, enter "Monday" in cell A2 and "70" in cell B2 , thus showing that the temperature reached 70 degrees on Monday.

How to Create a Bar Chart in Excel Picture 5How to Create a Bar Chart in Excel Picture 5

Complete data entry. Once you've completed the data import process, you're ready to use the data to create a bar chart.

Create charts

How to Create a Bar Chart in Excel Picture 6How to Create a Bar Chart in Excel Picture 6

Select all data. To do this, click in cell A1 , hold down the key , ⇧ Shiftand then click on the bottom value in column B. So, you have all your data selected.

If your graph has a lot of text, different numbers, and so on, you can also just click on the top left cell in the data group and then click on the bottom right cell while holding down the key ⇧ Shift.

How to Create a Bar Chart in Excel Picture 7How to Create a Bar Chart in Excel Picture 7

Click on the Insert tab . Located at the top of the Excel window, just to the right of the Home tab .

How to Create a Bar Chart in Excel Picture 8How to Create a Bar Chart in Excel Picture 8

Click on the "Bar chart" icon. This icon is in the "Charts" group at the bottom right of the Insert tab ; like a series of vertical bars.

How to Create a Bar Chart in Excel Picture 9How to Create a Bar Chart in Excel Picture 9

Click on the bar chart option. There will be many different templates available, depending on your operating system and whether you have purchased an Excel license or not, but some popular options include:

2-D Column – Represents data as a vertical bar.

3-D Column – Represents data as a three-dimensional vertical bar.

2-D Bar – Represents data as a simple graph with horizontal bars instead of vertical bars.

3-D Bar – Represents data as a three-dimensional horizontal bar.

How to Create a Bar Chart in Excel Picture 10How to Create a Bar Chart in Excel Picture 10

Customize charts. Once you decide on a chart format, you can use the "Design" section near the top of the Excel window to choose a different template, change the color, or change the chart type entirely.

The "Design" window appears only when you select a chart. To select a chart, click on the chart.

You can also click on the chart title to select it and then enter a new title. The title is usually at the top of the chart's window.

5 ★ | 1 Vote