Skip to content Skip to sidebar Skip to footer
Home / Chart

Have Pivot Chart Show Only Some Columns In Pivot Table

Pivot Chart And Pivot Table

Introduction

Pivot tables and charts are powerful tools in Microsoft Excel that allow you to summarize and analyze large sets of data. Pivot charts are a visual representation of pivot tables that make it easy to spot trends and patterns in your data. However, sometimes you may want to show only some columns in your pivot chart, while hiding others. In this article, we will show you how to do this.

Step 1: Create a Pivot Table and Chart

The first step is to create a pivot table and chart in Excel. To do this, follow these steps:

  1. Select the data that you want to analyze.
  2. Go to the Insert tab and click on PivotTable.
  3. Select the location where you want to place your pivot table and click OK.
  4. In the PivotTable Fields pane, drag and drop the columns that you want to analyze into the Rows and Columns boxes.
  5. Drag and drop the column that you want to visualize into the Values box.
  6. Select any cell in the pivot table and go to the Insert tab.
  7. Click on PivotChart and select the type of chart that you want to create.
Pivot Table And Chart

Step 2: Hide Columns in the Pivot Table

Now that you have created a pivot table and chart, you can hide columns in the pivot table that you don't want to show in the chart. To do this, follow these steps:

  1. Select the column that you want to hide.
  2. Right-click on the column and select Hide.
Hide Column In Pivot Table

Repeat this process for all the columns that you want to hide in the pivot table.

Step 3: Update the Pivot Chart

After hiding the columns in the pivot table, you need to update the pivot chart to show only the columns that you want to display. To do this, follow these steps:

  1. Select any cell in the pivot chart.
  2. Go to the Design tab and click on Select Data.
  3. In the Select Data Source dialog box, click on the Hidden and Empty Cells button.
  4. Select the option for Show data in hidden rows and columns.
  5. Click OK to close the dialog box.
  6. Click on the Edit button next to the Legend Entries (Series) box.
  7. In the Edit Series dialog box, select the columns that you want to show in the chart.
  8. Click OK to close the dialog box.
Update Pivot Chart

After following these steps, your pivot chart will show only the columns that you selected in the pivot table.

Conclusion

In conclusion, hiding columns in a pivot table and updating the pivot chart to show only some columns is a useful technique when you want to focus on specific data in your analysis. By following the steps outlined in this article, you can easily create a pivot chart that shows only the columns that you want to display.

Related video of Have Pivot Chart Show Only Some Columns In Pivot Table