Hide data without removal in PivotChart?

[alexpsyched]

Hi all,

In the attached, I would like to only display the orange bars where the value is "1". I have tried filtering to remove the "0" values, however this also changes my percentages to 100% for all rows as my Pivot is currently configured to show values as a % of row total.

Thanks.

[cbatrody]

Hi,

Can you not make the Blue bars colorless?

[alexpsyched]

That may work, but I was hoping for a more "technically correct" way to to render the Chart display.

Thanks for the creative input though. Never thought of that.

[cbatrody]

Yes, you can also accomplish this by filtering "1" on the chart (I have attached the snapshot here)

[alexpsyched]

I have tried that but it doesn't work properly as it also removes the values from my PivotTable.

[cbatrody]

Hi,

Please post a sample template of you workbook (excel format) using "Go Advanced" option below.

[alexpsyched]

Thank you for your help and time. Really appreciate it.

Please refer to the attached.

[cbatrody]

Hi,

Please find attached the updated file. Now you have a chart with bars that only display Percentage of "1"s. I added a counter column in the raw data to achieve this result.

Regards,
Chandra



Please click on ‘* Add Reputation’ if this was helpful

[alexpsyched]

That worked! Thanks for your help.