#Use secondary axis in excel for mac series
Right-click the series again and choose Change Series Chart Type.ġ2.
You can emphasize the difference - making the chart clearer - by turning one of the series into a line.
But having both sets of data as columns is confusing. All of a sudden, you can see the data!ġ1. In the Format Data Series dialog box, with the Series Options category selected, choose Secondary Axis, to plot that series on a secondary axis.ġ0. Right-click the selected series and choose Format Data Series. First, we’ll change the scale for this series. But click along the X-axis and you can select it, as you see here. Because the change in violence data is negative numbers, you can’t see that series. Of course, the data, specifically for the % change in violence isn’t right and that’s what we’ll change.Ĩ. Now, the weeks of the course are along the X-axis where they belong. You do this on the Chart Tools Design tab click the Switch Row/Column button in the Data group. You often have to switch the rows & columns. The weeks should be on the X -xis, along the bottom.
Return to your PowerPoint slide to look at the chart. Drag the bottom-right corner of the blue border to fit your data.Ħ. Copy the data from your spreadsheet to the clipboard, switch to the temporary Excel spreadsheet, click in cell A1, and paste.ĥ. A temporary Excel spreadsheet opens with dummy data. In the Insert Chart dialog box, choose one of the types of chart that you want. On the slide, click the Chart icon, which looks like a column/bar chart.ģ. In PowerPoint, right-click off the slide, choose Layout, and choose the Title & Content layout.Ģ. I didn’t have the actual numbers, so these numbers will be slightly different from the numbers used in the study.įollow these steps to create a chart like this in PowerPoint 2007 or 2010:ġ. Note: I found the actual chart online and estimated the numbers from the chart. Here’s what the data looks like in Excel. It compares police statistics of homicides, rapes and assaults during the course with the number of people who were on the course, which lasted 8 weeks. This chart is from a course of practitioners of the Transcendental Meditation technique that took place in 1993 in Washington, D.C. She is one of the top experts in the world on PowerPoint and specifically PowerPoint charts.Ĭharts like this are very useful when you’re comparing 2 very different types of data. I learned this feature of PowerPoint charts recently from my friend and fellow PowerPoint MVP, Echo Swinford. 2 different chart types–column and line.2 different Y-axes each with a different scale.How do you create a chart in PowerPoint that looks like this? It has:
0 kommentar(er)
