how to use microsoft excel to make a bar graph

Use a slide with a layout that contains content and click the Chart icon, or choose Insert tab, and then Insert Chart. Here are the basic steps to create the chart in PowerPoint from a data set:ġ. Let’s assume that you’ve already edited an Excel spreadsheet so that it contains only the data that will support your message. There are several ways to generate a chart in PowerPoint from Excel data, but here we’ll talk about one way. These two tables, or sets of data, would end up being two easily digestible slides, instead of one overloaded slide. For example, you could cover two related sets in one table and two other related sets in another.

Tip: If your data just has to be huge, see if you can divide the data into two sets. When you have only the data you need, you’re ready to create the chart in PowerPoint. One way to do this is to copy and paste data onto a separate Excel workbook tab. Instead of creating a chart from data in an entire Excel spreadsheet, first edit your spreadsheet. Too much data (sometimes called “data dump”) will overwhelm your audience, blunting your message. Instead, it’s a chart that shows only the data necessary to make the desired point clear – no less, no more. Charts display data in a visual format that audiences can easily grasp – if you design the chart and slide clearly and crisply.Ī crisp chart has nothing to do with your toaster’s setting. Īs a presenter, you probably use charts (also called graphs) in your presentations. To learn more about her books, and get free tips and reports go to. And, don’t forget to share this charting tip with your friends.By guest blogger Ellen Finkelstein, PowerPoint MVP and author of many PowerPoint skills books. Please share your views in the comment section, I would love to hear from you. Have you ever tried this before? And do you think we can use it in our dashboards? I’m sure you found this graph useful and it will help you in your work.

You can also use it in your dashboards and templates to give them an awesome look and for an effective way to make others understand data. And I believe that creating a people graph in Excel is really fun.

Infographics are superb in presenting data in a vivid way.

You can also paste it as an image in the worksheet by copy paste.

When you update any value in the source data, make sure to click on the graph once to update it.

With this, we can use it further in PowerPoint, send it in an email, upload it to the web, etc. There is an option to save it as an image.

How to use microsoft excel to make a bar graph