Tuesday, March 29, 2022

How to Make a Bar Graph in Excel

It's easy to spruce up data in Excel and make it easier to interpret by converting it to a bar graph. A bar graph is not only quick to see and understand, but it's also more engaging than a list of numbers. This wikiHow article will teach you how to make a bar graph of your data in Microsoft Excel.

[Edit]Steps

[Edit]Adding Data

  1. Open Microsoft Excel. It resembles a white "X" on a green background.
    Make a Bar Graph in Excel Step 1 Version 5.jpg
    • A blank spreadsheet should open automatically, but you can go to File > New > Blank if you need to.
    • If you want to create a graph from pre-existing data, instead double-click the Excel document that contains the data to open it and proceed to the next section.
  2. Add labels for the graph's X- and Y-axes. To do so, click the A1 cell (X-axis) and type in a label, then do the same for the B1 cell (Y-axis).
    Make a Bar Graph in Excel Step 2 Version 5.jpg
    • For example, a graph measuring the temperature over a week's worth of days might have "Days" in A1 and "Temperature" in B1.
  3. Enter data for the graph's X- and Y-axes. To do this, you'll type a number or word into the A or B column to apply it to the X- or Y- axis, respectively.
    Make a Bar Graph in Excel Step 3 Version 5.jpg
    • For example, typing "Monday" into the A2 cell and "70" into the B2 field might show that it was 70 degrees on Monday.
  4. Finish entering your data. Once your data entry is complete, you're ready to use the data to create a bar graph.
    Make a Bar Graph in Excel Step 4 Version 5.jpg

[Edit]Creating a Graph

  1. Select all of your data. To do so, click the A1 cell, hold down , and then click the bottom value in the B column. This will select all of your data.
    Make a Bar Graph in Excel Step 5 Version 5.jpg
    • If your graph uses different column letters, numbers, and so on, simply remember to click the top-left cell in your data group and then click the bottom-right while holding .
  2. Click the tab. It's in the editing ribbon, just right of the Home tab.
    Make a Bar Graph in Excel Step 6 Version 5.jpg
  3. Click the "Bar chart" icon. This icon is in the "Charts" group below and to the right of the Insert tab; it resembles a series of three vertical bars.
    Make a Bar Graph in Excel Step 7 Version 5.jpg
  4. Click a bar graph option. The templates available to you will vary depending on your operating system and whether or not you've purchased Excel, but some popular options include the following:
    Make a Bar Graph in Excel Step 8 Version 5.jpg
    • 2-D Column - Represents your data with simple, vertical bars.
    • 3-D Column - Presents three-dimensional, vertical bars.
    • 2-D Bar - Presents a simple graph with horizontal bars instead of vertical ones.
    • 3-D Bar - Presents three-dimensional, horizontal bars.
  5. Customize your graph's appearance. Once you decide on a graph format, you can use the "Design" section near the top of the Excel window to select a different template, change the colors used, or change the graph type entirely.
    Make a Bar Graph in Excel Step 9 Version 5.jpg
    • The "Design" window only appears when your graph is selected. To select your graph, click it.
    • You can also click the graph's title to select it and then type in a new title. The title is typically at the top of the graph's window.[1]

[Edit]Sample Bar Graphs

[Edit]Tips

  • Graphs can be copied and then pasted into other Microsoft Office programs like Word or PowerPoint.
  • If your graph switched the x and y axes from your table, go to the "Design" tab and select "Switch Row/Column" to fix it.

[Edit]Related wikiHows

[Edit]References



from How to of the Day https://ift.tt/KYyboAa

No comments:

Post a Comment