flowmi.blogg.se - Hide cells in excel for mac

#HIDE CELLS IN EXCEL FOR MAC FOR MAC#

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:

#HIDE CELLS IN EXCEL FOR MAC FOR MAC#

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.