Remove data from Pivot Graph

[mrd99]

I have a data set with customers, and the fields:

- CustomerNumber
- Category

They can be category: none, Gold or Platinum.

I need a pivot graph that shows the % of Gold and Platinum customers, and not showing the "none" value.
But, I don't know how to remove the "none" part from the data, but they should count as a base line for %.

This is what i get (with % Running of total in):
Gold - 50%
Platinum - 20%
none - 30%

For the pivot TABLE, that's fine. But not in a line graph, it should stop at 70% (50+20) and not go to 100%.

Help

[JeteMc]

This proposal employs formulas rather than a pivot table and pivot chart.
I assume that the issue you are having is similar to the pivot chart on the left of the attached file. I don't know of a way to make it display as you want because when "None" is removed as a category then the percentages reflect only Gold and Platinum.
The summary range on the right uses the following formulas.
For Category: =IFERROR(INDEX(Table1[Category],MATCH(0,INDEX(COUNTIF(K$2:K2,Table1[Category]),,),)),"")
For % Running Total: =IF(K3="","",SUM(L2,COUNTIFS(Table1[Category],K3)/COUNTA(Table1[Category])))
Note that the raw data in columns A:B is an Excel table so that the references to the Category column will change automatically as the table is expanded/contracted. (test by selecting cell B11 > press the Tab key > put a category into cell B12).
Note that "None" is not selected in the Horizontal Axis Labels area of the Select Data Source dialog box.
Let us know if you have any questions.

[josephteh]

In the PivotTable, replace the "None" under Category with spacebar " ". In the PivotChart, right-click on the "None" column (if you are using the Column Chart) and select No Fill and No Outline.

Show Only Selected Categories in Chart.png