How To Get My Data Labels To Not Round Up Powerpoint For Mac

This video shows you how you can format the labels on the x- and y axis in an.

By guest blogger Ellen Finkelstein, PowerPoint MVP and author of many PowerPoint skills books. To learn more about her books, and get free tips and reports go to. As a presenter, you probably use charts (also called graphs) in your presentations. Charts display data in a visual format that audiences can easily grasp – if you design the chart and slide clearly and crisply. A crisp chart has nothing to do with your toaster’s setting. Instead, it’s a chart that shows only the data necessary to make the desired point clear – no less, no more.

Vintage video editing apps for mac free. Too much data (sometimes called “data dump”) will overwhelm your audience, blunting your message. Limit the Data Instead of creating a chart from data in an entire Excel spreadsheet, first edit your spreadsheet. One way to do this is to copy and paste data onto a separate Excel workbook tab.

Then look at what you can eliminate. When you have only the data you need, you’re ready to create the chart in PowerPoint. Tip: If your data just has to be huge, see if you can divide the data into two sets. For example, you could cover two related sets in one table and two other related sets in another. These two tables, or sets of data, would end up being two easily digestible slides, instead of one overloaded slide. Creating the chart There are several ways to generate a chart in PowerPoint from Excel data, but here we’ll talk about one way. Let’s assume that you’ve already edited an Excel spreadsheet so that it contains only the data that will support your message.

Here are the basic steps to create the chart in PowerPoint from a data set: 1. Use a slide with a layout that contains content and click the Chart icon, or choose Insert tab, and then Insert Chart.

To change the layout of an existing slide, right-click off the slide, choose Layout, and choose Title and Content or another layout with the word “Content” in its name. The Insert Chart dialog opens. Properties for google mac desktop. Choose the type of chart you want. For this example, I’ll choose the default 2D column chart.

Note: Some types of charts are appropriate for specific types of data; your chart type should match your data. For example, if you have one row of data showing percentages that make up a whole, a pie chart would work better than a column chart. When you click OK, a temporary Excel spreadsheet opens, with dummy data. This spreadsheet is named “ Chart in Microsoft PowerPoint.” Now navigate to your Excel spreadsheet that contains the data you want for your chart, select the data, and copy it to the clipboard.

Go back to the temporary spreadsheet, click in cell A1, and paste. If your data is smaller than the dummy data, you’ll need to drag the lower right corner of the blue border inward; in the figure, a red arrow points to this corner. Go back to your PowerPoint slide to see the chart You may need to switch the columns and rows, which you do by clicking the Switch Row/Column button on the Chart Tools Design tab.