Need to create PIVOT chart using selected rows

Question

I have a PIVOT table with 10 rows.. Have a scenario to create Pivot charts by choosing the rows.. Is it possible to do that ...

Ex

Sample Pivot table 

name  product.cnt  sales.cnt  

aaa      10                20

bbb       5                 10

ccc        44                22

ddd        33               11

eee        22                10

need to create chart only for aaa and ccc.

Also is it possible to create one more pivot chart with bbb and eee.

Please let me know If you need more clarifications.

thanks

santhosh

Answer 1

Thank you Ketul Patel !

But am looking for  2 charts one with aaa & ccc in the filter and chart and the rest should be in the other char and in the second chart it should not have aaa & ccc even in the filter.

i tried a solution of creating pivot table first and created 2 charts from that. Is there any better solution available.

thanks

santhosh

Answer 2

Hi Santosh,

Yes, it is possible.

Use the filter to get PivotChart for only AAA and CCC or any of your selection

Results