Excel 2016 – How to have pivot chart show only some columns

The following steps show how to create a pivot table and chart that has two values (value and percent of total) but the chart only displays one value.

This process shows you how to hide values in the pivot chart.

  1. Select the table you want to create the pivot chart from
  2. Click on the ‘Insert’ ribbon menu
  3. Click on the ‘PivotChart’ button
  4. Drag the value you want to chart TWICE into the ‘Values’ box
  5. The pivot table will now how the value shown twice
  6. Right-click on the second value in the pivot table and choose ‘Show Values As’ -> ‘% of Grand Total’
  7. The pivot chart will update
  8. Now we want to hide the percent value from the chart. Excel doesn’t offer an easy solution to this – instead we need to use the formatting to make the column hidden.
  9. Right-click on the column you want to hide and choose ‘Format Data Series’
  10. The Format Data Series settings will appear at the right of the screen
  11. On the Series Options’ tab set ‘Series Overlap to ‘100%’
  12. Now open the ‘Fill & Line’ tab (paint bucket icon)
  13. Set ‘Fill’ to ‘No fill’
  14. Set ‘Border’ to ‘No line’
  15. The pivot chart will now only display one value – hiding the percentage of total value from the pivot table



Reference: https://superuser.com/questions/815798/have-pivot-chart-show-only-some-columns-in-pivot-table

Tagged in

2 comments on “Excel 2016 – How to have pivot chart show only some columns

  1. In my pivot table when i put on filters

    If i select salesman 1
    Columns are blank(same column may have values for salesman 2 or 3 or4)
    Now i want to give a print out for salesman 1 hiding the zero value/data/figures for s1


    When i select salesman2 the colunm with datas/value/figures hidden for salesman1 should appear if there is value in it

Leave a Comment

Your email address will not be published. Required fields are marked *