Home | Products | PowerPoint | PowerPoint Tutorials | Charts

Adding and Deleting Chart Series and Categories in PowerPoint 2011 for Mac

Learn how to add and delete Series and Categories for charts in PowerPoint 2011 for Mac.


Author:

Product/Version: Microsoft PowerPoint 2011
OS: Mac OS X







Any new chart that you add within PowerPoint 2011 has its roots in Excel -- all the data for the chart is also stored within an Excel sheet. Editing chart data within Excel involves a little more than just changing values. There may be times when you want to add a new Series or Category -- in chart terminology, Series are represented by individual columns within your Excel sheet -- these show up as the columns within a typical column chart. Categories on the other hand are essentially a set of series. In the sample chart shown later on this page within Figure 1, the Series are Grapes, Apples, Bananas, etc. -- and the Categories are the years 2009 through 2012.

Chart selected on the slide
Figure 1: Chart selected on the slide

We will continue exploring our sample chart, as shown in Figure 1, above -- let's say we want to add a whole new series for Currants. Let's now learn how we can add and delete Series and Categories:

  1. Open your presentation, navigate to slide containing the chart to be edited and select the chart as shown previously in Figure 1.

  2. Right-click (or Ctrl+click) the selected chart -- from the context menu, choose the Edit Data option to open the Excel sheet containing chart data, as shown in Figure 2.

    Excel sheet containing chart data
    Figure 2: Excel sheet containing chart data

    Alternatively, click the Edit button within the Charts tab of the Ribbon.

Now, follow these guidelines to add or delete Series or Categories, as required:

Add New Series or Category in the End

Follow these steps to add a new Series or Category in the end:

  1. Place your cursor on the lower-right corner of the data table so that it turns into a pointer, as shown highlighted in red within Figure 3.

    Cursor changed
    Figure 3: Cursor changed

  2. Now click and drag this pointer (highlighted in red within Figure 3, above) rightwards as shown in Figure 4.

    Drag the pointer rightwards to add a new Series
    Figure 4: Drag the pointer rightwards to add a new Series

  3. Type in the values you need -- as you can see in Figure 5, below -- we included the name of the Fruit in the Heading row and then entered some values below.

    New Series added and edited
    Figure 5: New Series added and edited

  4. While keeping your Excel sheet open, navigate to your PowerPoint slide (use the Command+Tab keyboard shortcut to navigate between open applications). You'll see that a new Series has been added to our chart, as shown in Figure 6, below (compare with the chart in Figure 1, earlier on this page).

    Chart reflecting the changes after added with new Series
    Figure 6: Chart reflecting the changes after added with new Series

  5. Similarly, to add a new Category in the end, bring up the corner pointer (highlighted in red within Figure 3, above) and click and drag it downwards as shown in Figure 7, below.

    Drag the pointer downwards to add a new Category
    Figure 7: Drag the pointer downwards to add a new Category

  6. Type in the values you need -- as you can see in Figure 8, below -- we typed the year 2013 in the Heading column and then entered some values below.

    New Category added and edited
    Figure 8: New Category added and edited

  7. While keeping your Excel sheet open, navigate to your PowerPoint slide (use the Command+ Tab keyboard shortcut to navigate between open applications). You'll see that a new Series has been added to our chart, as shown in Figure 9, below (compare with the charts in Figures 1 and 9).

    Chart reflecting the changes after added with new Category
    Figure 9: Chart reflecting the changes after added with new Category

Add New Series or Category in Between

Follow these steps to add a new Series or Category in between:

  1. To add a new Series somewhere in between, select the column representing the subsequent Series, and right-click (or Ctrl+click) the Column Header -- from the resultant contextual menu, select the Insert option as shown in Figure 10. Thereafter just add new data as explained in the preceding section.

    Insert a new Series in between
    Figure 10: Insert a new Series in between

  2. Similarly, to add a new Category somewhere in between, select the row representing the subsequent Category, and right-click (or Ctrl+click) the Row Header -- from the resultant contextual menu, select the Insert option as shown in Figure 11. Thereafter just add new data as explained in the preceding section.

    Insert a new Category in between
    Figure 11: Insert a new Category in between

  3. New Series or Categories will be added to your chart -- navigate to your PowerPoint slide (use the Command+Tab keyboard shortcut to navigate between open applications) to see the newly added Series or Categories.

Delete Series and Category

Follow these steps to delete a Series or Category:

  1. To delete a particular Series select the corresponding Column and right-click or Ctrl+click) the Column Header -- from the resultant contextual menu, select the Delete option as shown in Figure 12.

    Delete a Series
    Figure 12: Delete a Series

    Tip: You can also delete a Series within PowerPoint -- just click once (don't double click) on the Series to be deleted within the chart, and press the Delete ⌦ key on your keyboard.


  2. To delete a particular Category select the corresponding Row and right-click (or Ctrl+click) the Row Header -- from the resultant contextual menu, select the Delete option as shown in Figure 13.

    Delete a Category
    Figure 13: Delete a Category

When you are done with editing chart data within the Excel sheet, go ahead and close Excel -- the changes will automatically reflect within the chart on your PowerPoint slide. Save your presentation often!

Tip: You don't always have to delete Series or Categories - sometimes you can just hide them so that the data is still available, just in case you want to retrieve them again at a later date -- learn more in our Hiding Series and Categories within Power Point 2011 for Mac tutorial.

See Also: Adding and Deleting Chart Series and Categories in PowerPoint 2013 for Windows

 

Office 2008 for Mac All-in-One For Dummies Office 2011 for Mac All-in-One For Dummies

If you liked this tutorial, do look at this book, authored by Geetesh Bajaj and James Gordon.

This book is the single most comprehensive content for Microsoft's latest Office suite offering for Mac users.

Check the book on Amazon.com...




comments powered by Disqus




Subscribe to Indezine
Follow Indezine

Follow Indezine on Pinterest
Share This Page
Bookmark and Share
Translate Page


Like This Page
Like This Site



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-2016, Geetesh Bajaj. All rights reserved.

since November 02, 2000