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

Return to Full Article

Coming soon

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 15 Helpful 28
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 8 Helpful 17
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 19 Helpful 20
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 11 Helpful 12
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 9 Helpful 9
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 30 Helpful 20
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 10 Helpful 9
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 10 Helpful 8
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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 2