How to Create a Bar Chart in Excel: 10 Steps

Table of contents:

How to Create a Bar Chart in Excel: 10 Steps
How to Create a Bar Chart in Excel: 10 Steps
Anonim

This article explains how to visually represent data in a Microsoft Excel document using a bar chart.

Steps

Part 1 of 2: Enter the Data

Make a Bar Graph in Excel Step 1
Make a Bar Graph in Excel Step 1

Step 1. Launch Microsoft Excel

Double-click the program icon, which has a white "X" on a green background.

If you want to use an Excel file that already has data, double-click the corresponding icon and go to the next section of the article

Make a Bar Graph in Excel Step 2
Make a Bar Graph in Excel Step 2

Step 2. Click on the Empty Workbook (on Windows) or Excel Workbook (on Mac) item

It is located in the upper left of the pane where the Excel templates are displayed.

Make a Bar Graph in Excel Step 3
Make a Bar Graph in Excel Step 3

Step 3. Enter the X and Y axis labels of the chart

Click the cell A1 (corresponding to the X axis) and enter the label you want to assign, then click the cell B1 (corresponding to the Y axis) and type the label you prefer.

For example, in the case of a graph that shows the trend of temperatures over the days of the week, you could enter the label "Days" in the cell A1 and "Temperatures" in the cell B1.

Make a Bar Graph in Excel Step 4
Make a Bar Graph in Excel Step 4

Step 4. Enter the data corresponding to the X axis and Y axis

Type their values into the cells of the column TO or B. to be linked respectively to the X and Y axis of the graph.

For example, enter the word "Monday" in the cell A2 and the value "20" in the cell B2 to indicate that on Monday the temperature was 20 ° C.

Make a Bar Graph in Excel Step 5
Make a Bar Graph in Excel Step 5

Step 5. Complete the data entry

Once you have completed creating the data table you will be ready to use it to create the bar chart.

Part 2 of 2: Creating the Chart

Make a Bar Graph in Excel Step 6
Make a Bar Graph in Excel Step 6

Step 1. Select all the data to display in the chart

Click the cell A1, hold down the ⇧ Shift key, then click the last cell that contains the set of values to be graphed, i.e. the last data you entered in the column B.. This will select the entire data area.

If you have entered the values in another area of the Excel sheet, simply remember to click the first cell in the upper left of the data group to be displayed in the chart, then click the last cell in the lower right while holding the key. ⇧ Shift

Make a Bar Graph in Excel Step 7
Make a Bar Graph in Excel Step 7

Step 2. Click on the Insert tab

It is located at the top of the Excel window, to the right of the tab Home.

Make a Bar Graph in Excel Step 8
Make a Bar Graph in Excel Step 8

Step 3. Click on the "Histogram" icon

It is placed within the group Graphs of the card insert and is characterized by three vertical bars.

Make a Bar Graph in Excel Step 9
Make a Bar Graph in Excel Step 9

Step 4. Choose the type of chart to create

The templates available vary based on your computer's operating system and whether or not you have purchased your copy of Excel. However, usually the options available include the following graphs:

  • 2-D columns: the selected data will be represented simply with vertical bars.
  • 3-D columns: in this case three-dimensional vertical bars will be used.
  • 2-D bars: a chart will be created in which there are simple horizontal bars instead of vertical ones.
  • 3-D bars: in this case the horizontal bars will be three-dimensional.
Make a Bar Graph in Excel Step 10
Make a Bar Graph in Excel Step 10

Step 5. Customize the look of the chart

After choosing the type of chart to use, you can access the "Design" tab of the Excel ribbon to choose one of the available styles. You also have the option to change the color scheme or change the chart type.

  • The "Design" tab is displayed only when the chart pane is selected. To perform this operation, click with the mouse on the graph box.
  • You can also change the chart title by selecting the existing one and typing what you want to assign to your histogram. The title is usually placed at the top of the box.

Advice

  • Excel charts can be copied and pasted into other Microsoft Office programs, such as Word or PowerPoint.
  • If the data associated with the X axis and the Y axis appear reversed in the chart, go to the "Design" tab and select the "Invert rows / columns" option.

Recommended: