Hide the 100% column when using the "Show value as % Of another base item" in Excel Pivot Chart

Excel Pivot Charts are a powerful tool for visualizing data and gaining insights. One useful feature is the ability to show values as a percentage of another base item. However, sometimes you may encounter a situation where you want to hide the 100% column in the Pivot Chart. In this article, we will guide you through the process of hiding the 100% column in Excel Pivot Charts.

Step 1: Create a Pivot Chart

To begin, you need to create a Pivot Chart from your data. Here's a quick refresher on how to do that:

1. Select the range of data you want to include in the Pivot Chart.
2. Go to the "Insert" tab in the Excel ribbon.
3. Click on the "PivotChart" button.
4. Choose the type of chart you want to create (e.g., column chart, bar chart, etc.).
5. Click "OK" to create the Pivot Chart.

Step 2: Add Data to the Pivot Chart

Once you have created the Pivot Chart, you need to add data to it. Here's how:

1. Right-click on the Pivot Chart and select "PivotChart Options" from the context menu.
2. In the "PivotChart Options" dialog box, go to the "Data" tab.
3. Click on the "Add" button to add data to the Pivot Chart.
4. In the "Add Data" dialog box, select the data you want to add to the Pivot Chart.
5. Click "OK" to add the data to the Pivot Chart.

Step 3: Show Values as % of Another Base Item

Now that you have added data to the Pivot Chart, you can show values as a percentage of another base item. Here's how:

1. Right-click on any value in the Pivot Chart and select "Show Values As" from the context menu.
2. In the "Show Values As" submenu, select "% of" and then choose the base item you want to use for the calculation.
3. Excel will automatically calculate the percentages and update the Pivot Chart accordingly.

Step 4: Hide the 100% Column

If you want to hide the 100% column in the Pivot Chart, follow these steps:

1. Right-click on the Pivot Chart and select "Select Data" from the context menu.
2. In the "Select Data Source" dialog box, go to the "Legend Entries (Series)" section.
3. Select the 100% column from the list of series.
4. Click on the "Remove" button to hide the 100% column.
5. Click "OK" to apply the changes.

That's it! You have successfully hidden the 100% column in the Pivot Chart.

If you ever want to show the 100% column again, simply follow the same steps and add it back to the Pivot Chart.

Remember, Pivot Charts are highly customizable, and you can experiment with different settings to get the desired visual representation of your data. Don't be afraid to explore and try new things!

Conclusion

In this article, we have learned how to hide the 100% column in Excel Pivot Charts when using the "Show Values As % of Another Base Item" feature. By following the step-by-step instructions provided, you can easily customize your Pivot Chart to display the data exactly as you want.

We hope this article has been helpful to you. If you have any further questions or need additional assistance, please feel free to consult the references below or reach out to our tech support team.

Explore other helpful articles on tech support to enhance your Excel skills and troubleshoot common issues.