Indezine Logo

  This is the print version of this page. All content is copyright Indezine.com 2000-2021.



Change Order of Chart Data Series in PowerPoint 2011 for Mac

Learn how to change the order in which chart data series are displayed in PowerPoint 2011 for Mac. This task is so much easier if you follow the steps in order.


Author:

Product/Version: PowerPoint 2011 for Mac

OS: Mac OS X



Learn PowerPoint

Explore the Data Assistant warning in some versions of PowerPoint.



You may have created the perfect chart, but what if you need to change the order of your data series? What if you have to reverse their sequence, or even swap the position of some series? Let's say your data series are grapes, apples, and bananas—and these show up in exactly the same order, as shown in Figure 1, below.

Data Series selected within the Chart
Figure 1: Data series selected in the chart

Now, what if you want to change this order to grapes, bananas, and apples? Yes, you can make these changes in the Excel sheet that contains the data for your PowerPoint chart, but is there an easier way? Indeed, there is!

To start with, you need to select your chart. Then, follow these steps to learn more in PowerPoint 2011 for Mac.

  1. Click on any data series to select it. In Figure 1, above, you can see that the entire grapes series has been selected.
  2. With the data series selected, access either the Chart Layout or the Format tabs of the Ribbon. Both these tabs contain the Current Selection group that you can see in Figure 2 towards the extreme left. Within this group, the Chart Elements selection box is shown highlighted in red within Figure 2, below. This selection box shows the name of the selected chart element. Make sure the series is still selected. Then, click the Format Selection button, highlighted in blue within Figure 2.
  3. Format Selection button
    Figure 2: Format Selection button
  4. Alternatively, right-click (or Ctrl + click) the selected series and from the contextual menu, select the Format Data Series option.
  5. Either of the above options will summon the Format Data Series dialog box. Select the Order option within the sidebar as shown highlighted in red within Figure 3, below. Within the dialog box, you can see all Data Series listed as shown highlighted in blue within Figure 3, in the same order as they appear in the selected chart. Also, notice that in Figure 3, the Move Up button is grayed out. This is because the grapes data series we have selected is in the first position, so it can't be moved up further.
  6. List of Data Series within Format Data Series dialog box
    Figure 3: List of data series within Format Data Series dialog box
  7. Within the data series list, click on the series that you want to change the order of. In Figure 4, below, you can see that we have selected the second data series named Apples. You can also see that the Move Up button is now active, since the selected data series is in the middle position and it can be moved up or down.
  8. Select the required Data Series
    Figure 4: Select the required data series
  9. If you want to move the selected data series to an earlier position, then click the Move Up button. If you want to move it towards the end, click the Move Down button. As and when you click these buttons, you can see the changes happening in the selected chart simultaneously. In Figure 5 you can see that we have moved the Apples series to the end.
  10. Selected Data Series moved downwards
    Figure 5: Selected Data Series moved downwards
  11. Once you have reordered the data series as required, click the OK button within the Format Data Series dialog box. In Figure 6 you can see that the Apples series has been moved to the end (compare to Figure 1)
  12. Data Series reordered
    Figure 6: Data Series reordered
  13. Save your presentation often.

See Also:

Chart Data: Change Order of Chart Data Series (Glossary Page)

Change Order of Chart Data Series in PowerPoint 2013 for Windows

You May Also Like: Thin Smiles, Thinner Audiences! | Soundscapes PowerPoint Templates


Popular Posts

Creating Anchor Points for Connectors in PowerPoint 2010 for Windows
Learn how to create Anchor Points for connectors in PowerPoint 2010.

Working With Slide Numbers in PowerPoint 2016 for Windows
Learn how to add Slide Numbers on slides and Masters and more tricks on making them work to your will in PowerPoint 2016 for Windows.

Texture Fills for Slide Backgrounds in PowerPoint 2013 for Windows
Use texture fills for slide backgrounds in PowerPoint 2013 for Windows.

Adding More Guides in PowerPoint 2016 for Windows
Learn how to add more guides in PowerPoint 2016 for Windows.



Feature List 01 (Layout with Tabs)

The Feature List Layout comprises three sample PowerPoint presentations: one each to create a visual list for 4 features, 5 features, and 6 features. These work great when you have too much information to fit within one slide. This solution lets you use multiple slides, but the visual result is still that of one single slide!

Buy and Download Feature List 01 (Layout with Tabs) for $4.99+ (671 kb)

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Change Order of Chart Data Series in PowerPoint 2011 for Mac.


Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Advertise | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2021, Geetesh Bajaj. All rights reserved.