Q&A for How to Make a Bar Graph in Excel

Return to Full Article

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.
  • Question
    How do I title the graph?
    Community Answer
    Double click on it or look at the settings, usually they can be found on the right hand side of the graph.
  • Question
    How can I create a bar graph template that can be used over and over as a new graph by simply changing the data in the spreadsheet fields?
    Vasili Karalewich
    Community Answer
    Make a blank table, then highlight the table and insert the graph. The graph will be blank (all white), so just put in fake data to make sure it works. Then, clear the table and copy the document. Make a new copy of the spreadsheet every time you need to use the template.
  • Question
    How can I copy and paste a graph?
    Community Answer
    If you want to copy from excel and paste to word, for instance, then right click on the graph and select 'copy' from the drop-down menu, and paste it into your word document.
  • Question
    How do I add a source note at the bottom?
    Vasili Karalewich
    Community Answer
    Just add a text box right on top of the graph -- this will automatically group to the graph so when you move it, it moves with it.
  • Question
    How do I make Excel plot only one element?
    Community Answer
    Only highlight the data you want to make a graph for in your selection. Then when you create your graph, only this data will be displayed.
  • Question
    How can I make one graph using two separate tables?
    Community Answer
    Use the control button to select the two sets of data - x first and Y after.
Ask a Question

      Return to Full Article