Share via

Need to create PIVOT chart using selected rows

Anonymous
2015-08-28T15:32:50+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2015-08-31T15:21:36+00:00

    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

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2015-08-28T19:52:00+00:00

    Hi Santosh,

    Yes, it is possible.

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

    Results

    Was this answer helpful?

    0 comments No comments