#Office for mac 2011 unhide rows series
Alternatively, select both the Column Headers of the columns before and after the hidden column.įigure 5: Cursor changed to point the hidden Series 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).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).įigure 4: Chart reflecting the result of hiding the Series While keeping your Excel sheet open, navigate to your PowerPoint slide (use the ⌘+ Tab keyboard shortcut to navigate between open applications).Notice that the column C, representing Apples no longer shows in between columns B and D, as highlighted in red within Figure 3.įigure 3: Series hidden within the Excel data This step will hide the selected series (Apples), as shown in Figure 3, below.From the resultant contextual menu, select the Hide option as shown in Figure 2.
Then right-click (or Ctrl+ click) the Column Header. To do so, you will need to click the Column Header to select the entire column (series) to be hidden. We want to hide the entire 'Apples' series. Thereafter, follow the steps explained in the subsequent two sections to hide or unhide your data: Hide/Unhide a Seriesįollow these steps to hide/unhide a series in your chart: Learn more about this process in our Edit Chart Data in PowerPoint 2011 for Mac tutorial. We will use this chart as a sample chart to show you how its appearance changes after hiding a given series or category.īefore you proceed further, make sure you bring up the Excel sheet that contains the data related to your PowerPoint chart. Look at the chart shown in Figure 1, below. The solution is to temporarily hide values you no longer need, and then unhide as and when you want to reveal those values.
However deleting is not always the best option, especially if you want to retrieve those values later whenever required. Once you delete any of these values, they no longer show on your chart, and so the level of comparison reduces. However, almost any chart type, even if it is not a column chart compares a set of values. For some charts, this data may also be represented as values or a legend. 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.
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.
0 kommentar(er)
