Indezine Logo




Hiding Chart Series and Categories in PowerPoint 2011 for Mac

Learn how to hide series and categories for charts in PowerPoint 2011 for Mac. We also look at persistent series and categories that show up on a chart even after you hide them.


Author:

Product/Version: PowerPoint 2011 for Mac

OS: Mac OS X



Learn PowerPoint

What to do if outlines from TextEdit on Mac OS X don't import in PowerPoint?



In PowerPoint 2011 for Mac, the entire data that shows up on your chart in the form of series and categories is stored within an Excel sheet. These series and categories may show up on your chart in different ways—sometimes as an individual column or a set of columns within a column chart. For some charts, this data may also be represented as values or a legend. However, almost any chart type, even if it is not a column chart compares a set of values. Once you delete any of these values, they no longer show on your chart, and so the level of comparison reduces. However deleting is not always the best option, especially if you want to retrieve those values later whenever required. The solution is to temporarily hide values you no longer need, and then unhide as and when you want to reveal those values.

Look at the chart shown in Figure 1, below. We will use this chart as a sample chart to show you how its appearance changes after hiding a given series or category.

Chart showing default status of Gridlines
Figure 1: A sample chart

Before you proceed further, make sure you bring up the Excel sheet that contains the data related to your PowerPoint chart. Learn more about this process in our Edit Chart Data in PowerPoint 2011 for Mac tutorial. Thereafter, follow the steps explained in the subsequent two sections to hide or unhide your data:

Hide/Unhide a Series

Follow these steps to hide/unhide a series in your chart:

  1. Look at Figure 2, below. We want to hide the entire 'Apples' series. To do so, you will need to click the Column Header to select the entire column (series) to be hidden. Then right-click (or Ctrl+click) the Column Header. From the resultant contextual menu, select the Hide option as shown in Figure 2.
  2. Select the Hide option
    Figure 2: Select the Hide option
  3. This step will hide the selected series (Apples), as shown in Figure 3, below. Notice that the column C, representing Apples no longer shows in between columns B and D, as highlighted in red within Figure 3.
  4. Series hidden within the Excel data
    Figure 3: Series hidden within the Excel data
  5. While keeping your Excel sheet open, navigate to your PowerPoint slide (use the +Tab keyboard shortcut to navigate between open applications). You'll see that the hidden 'Apples' series is no longer showing in the chart, as shown in Figure 4 (compare with the chart in Figure 1, earlier on this page).
  6. Chart reflecting the result of hiding the Series
    Figure 4: Chart reflecting the result of hiding the Series
  7. To restore the hidden series, first hover your cursor over the position of the hidden series in the Column Header so that the cursor changes to what you see in Figure 5 (highlighted in red). Alternatively, select both the Column Headers of the columns before and after the hidden column.
  8. Cursor changed to point the hidden Series
    Figure 5: Cursor changed to point the hidden Series
  9. Now, right-click to bring up the contextual menu shown in Figure 6 and select the Unhide option.
  10. Select the Unhide option to reveal the hidden Series
    Figure 6: Select the Unhide option to reveal the hidden Series
  11. Doing so will display the hidden series in both the Excel data as well as the Chart on your PowerPoint slide.

Hide/Unhide a Category

Follow these steps to hide/unhide a category in your chart:

  1. Look at Figure 7, below. We want to hide the category representing the year 2011. To do so, you will need to click the Row Header to select the entire row (category) that we want to hide. Then right-click (or Ctrl+click) the Row Header. From the resultant contextual menu, select the Hide option as shown in Figure 7, below.
  2. Select the Hide option to hide the Category
    Figure 7: Select the Hide option to hide the Category
  3. This action will hide the selected category (2011) as shown in Figure 8. Notice that the 4th row representing the year 2011 is no longer showing between 3rd and 5th rows, as highlighted in red within Figure 8.
  4. Category hidden within the Excel data
    Figure 8: Category hidden within the Excel data
  5. While keeping your Excel sheet open, navigate to your PowerPoint slide (use the +Tab keyboard shortcut to navigate between open applications). You'll see that the hidden category is no longer showing in the chart, as shown in Figure 9, below (compare with chart in Figure 1, earlier on this page).
  6. Chart reflecting the result of hiding the Category
    Figure 9: Chart reflecting the result of hiding the Category
  7. To restore the hidden category, first hover your cursor over the position of the hidden category in the Row Header so that the cursor changes to what you see in Figure 10 (highlighted in red). Alternatively, select both the Row Headers for the rows before and after the hidden row.
  8. Cursor changed to point the hidden Category
    Figure 10: Cursor changed to point the hidden Category
  9. Then, right-click to get a contextual menu and select the Unhide option as shown in Figure 11.
  10. Select the Unhide option to reveal the hidden Category
    Figure 11: Select the Unhide option to reveal the hidden Category
  11. Doing so will unhide the hidden category in both the Excel data as well as the Chart on your PowerPoint slide.

When you are done with hiding/showing the series or categories within your Excel sheet, go ahead and close Excel. The changes will automatically reflect within the chart on your PowerPoint slide.

More about Hiding Series and Categories

Sometimes when you are trying to hide a series or a category, you may find that even though you have hidden them within the Excel sheet, they are still visible in the chart! To learn how to solve this issue, follow these steps:

  1. Click the down-arrow of the Edit button (highlighted in red within Figure 12) to open a small menu that you can see in in Figure 12. From this menu, select the Select Data in Excel option (refer to Figure 12 again).
  2. Select Data in Excel option
    Figure 12: Select Data in Excel option
  3. Doing so opens the Excel sheet containing the chart data along with the Select Data Source dialog box that you can see in Figure 13. Here, make sure that the Show data in hidden Rows and Columns check-box is 'deselected' as shown in Figure 13 (highlighted in red). Click OK button.
  4. Select Data Source dialog box
    Figure 13: Select Data Source dialog box
  5. This step will result in hiding those series or categories from the chart, which were hidden in the Excel chart data.

See Also:

Chart Data: Hiding Chart Series and Categories (Glossary Page)

Hiding Chart Series and Categories in PowerPoint 2013 for Windows

You May Also Like: Reduce Stress and Save Time: by Claudyne Wilder | Hollywood PowerPoint Templates


Popular Posts

Character Spacing in PowerPoint 2013
Character Spacing in PowerPoint 2013
Explore Character Spacing options in PowerPoint 2013.

Add Secondary Value Axis to Charts in PowerPoint 2013 for Windows
Add Secondary Value Axis to Charts in PowerPoint 2013 for Windows
Learn how to add a Secondary Value axis to charts in PowerPoint 2013 for Windows.

Ten Easy Topics for Pecha Kucha
Ten Easy Topics for Pecha Kucha
But what are simple topics, that excite you, and are interesting to your audiences? Of course, if you already have a topic, you need not read further, but if you are still looking for ideas, here are ten easy topics that you can use for your Pecha Kucha presentations.

Drawing Arcs in PowerPoint
Drawing Arcs in PowerPoint
Explore how you can draw an Arc shape in PowerPoint.



Handmade Slides: Pushpins for PowerPoint

These “pushpin” graphics are already placed in PowerPoint slides. Just copy them and paste within your slides to create a look that makes a picture, shape, or anything else appear as if it has been pushed onto a surface, board, or wall with a pin! These ready-made pushpins are already within PowerPoint slides, and have been provided in five colors. Just copy them and paste them on your slides.

Download these Pushpins for just $19.99

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Hiding Chart Series and Categories 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.