Switch Series and Categories for Charts in PowerPoint 2013
Learn how to switch data for your Series and Categories in PowerPoint 2013.
Author: Geetesh Bajaj
Product/Version: Microsoft PowerPoint 2013
OS: Windows 7 and 8
Any typical Column chart contains two sets of data -- one set shows as the Series within your charts, and the other set ends up representing the Categories. By default, the Series show up as the Legend (and columns) within the chart. Categories on the other hand constitute the groups of these individual columns.
In our sample chart in PowerPoint 2013 that you can see in Figure 1, below, the individual fruits (Grapes, Apples, and Bananas) are the Series whereas the years (Year 2011, Year 2012, Year 2013, and Year 2014) constitute the Categories.
Figure 1: Chart with three Series and four Categories selected
You can quickly swap the visual representation of Series and Categories in the chart. For example, our chart currently includes 3 Series and 4 Categories. We can change it to show 4 Series and 3 categories, as shown in Figure 3, later on this page.
Follow these steps to swap Series and Categories:
- Select the chart that you want to swap Series and Categories for. If you don't have an existing chart,
insert a new chart in your slide. For this tutorial
we have selected a Column chart, as shown in Figure 1, above.
- With the chart still selected, access the Chart Tools Design tab of the
Ribbon and make sure the Switch Row/Column
button is active, as shown highlighted in red within Figure 2.
Figure 2: Switch Row/Column button
Note: Is the Switch Row/Column button greyed out? This indicates that the Excel sheet containing the chart data is not open. To open the Excel sheet containing the chart data, just click the Edit Data button (highlighted in blue within Figure 2, above). This opens the Excel sheet containing the chart data. Now, come back to PowerPoint, and you will see that the Switch Row/Column button is no longer grayed out.
- To switch the rows and columns of your chart, click the Switch Row/Column button. This will modify your chart by switching the Categories and Series, as shown in
Figure 3 (compare Figures 1 and 3).
Figure 3: Chart Categories and Series interchanged
Note: If your chart's Category names contain just numbers and no alphabets, for example if we remove the word 'Year' from our sample chart's category names, then clicking the Switch Row/Column button will not achieve the desired result -- that's because the charting engine treats those cells as numbers and uses them to populate series values and categories. So, if you want to switch rows and columns, make sure that your chart's Category names are formatted as Text -- learn more in our Format Cells As Text in Excel 2013 tutorial.
If you want the chart to get back to its original status, click the Switch Row/Column button again that you saw in Figure 2 earlier on this page.
- Save your presentation often.
Have your ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?
Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences E-Book.