PDF download Download Article
Craft beautiful charts and graphs in no time
PDF download Download Article

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.

How to Construct a Bar Graph on Excel

  1. Add labels for the graph in two separate columns.
  2. Enter the data below the two columns you create.
  3. Highlight all of the data with your cursor.
  4. Click “Insert” in the toolbar and select the graph you’d like to create.
Part 1
Part 1 of 2:

Adding Data

PDF download Download Article
  1. It resembles a white "X" on a green background.
    • 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. To do so, click the A1 cell (X-axis) and type in a label, then do the same for the B1 cell (Y-axis).
    • For example, a graph measuring the temperature over a week's worth of days might have "Days" in A1 and "Temperature" in B1 .
    Advertisement
  3. 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.
    • For example, typing "Monday" into the A2 cell and "70" into the B2 field might show that it was 70 degrees on Monday.
  4. Once your data entry is complete, you're ready to use the data to create a bar graph.
  5. Advertisement
Part 2
Part 2 of 2:

Creating a Graph

PDF download Download Article
  1. To do so, click the A1 cell, hold down ⇧ Shift , and then click the bottom value in the B column. This will select all of your data.
    • 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 ⇧ Shift .
    EXPERT TIP

    Joseph Meyer

    Math Teacher
    Joseph Meyer is a High School Math Teacher based in Pittsburgh, Pennsylvania. He is an educator at City Charter High School, where he has been teaching for over 7 years. Joseph is also the founder of Sandbox Math, an online learning community dedicated to helping students succeed in Algebra. His site is set apart by its focus on fostering genuine comprehension through step-by-step understanding (instead of just getting the correct final answer), enabling learners to identify and overcome misunderstandings and confidently take on any test they face. He received his MA in Physics from Case Western Reserve University and his BA in Physics from Baldwin Wallace University.
    Joseph Meyer
    Math Teacher

    Develop strong graphing skills. Drawing graphs by hand will help you develop foundational graphing skills, especially in understanding scales and axes. This will build a strong base for you to use helpful online tools to visualize complex relationships, perform calculations, and prepare for standardized tests.

  2. It's in the editing ribbon, just right of the Home tab.
  3. This icon is in the "Charts" group below and to the right of the Insert tab; it resembles a series of three vertical bars.
  4. 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:
    • 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. 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.
    • 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]
  6. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How can I change the graph from horizontal to vertical?
    Community Answer
    'Bar Graph' is horizontal. 'Column Chart' is the same but vertical, so use that instead.
  • Question
    How do I move an Excel bar graph to a Word document?
    Community Answer
    You can copy and paste the graph. Do this the same way you'd copy and paste regular text.
  • Question
    How do I adjust the bar graph width in Excel?
    Community Answer
    Click on the element you want to adjust. For example, if you want to adjust the width of the bars, you would click on the bars. If that doesn't bring up options, try right clicking. Decreasing the gap width will make the bars appear to widen. If you have more than one set of data (i.e. the cost of two or more items over a given time span), you can also adjust the series overlap. If you're not satisfied with the automatic layout of the axes, you can adjust these at your own peril.
See more answers
Ask a Question
      Advertisement

      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.
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!
      Advertisement

      About This Article

      Thanks to all authors for creating a page that has been read 1,307,443 times.

      Is this article up to date?

      Advertisement