CODEWITHSUNDEEP
excelpivot-tablebubble-chart
Thomas H
Thomas H

Reputation: 51

Make a bubble chart in excel from a pivot table

Is there a way to make a bubble chart from a pivot table in excel? When I try do this I get a message that says that bubble charts and stock charts doesnt work with pivot tables.

Upvotes: 0

Views: 9867

Answers (1)

BoTz
BoTz

Reputation: 492

Do you need the pivot table to stay dynamic? And if so, will the pivot table change in size? If the answer to either of these is no, these work-arounds should work:

option 1 - You only need the values from the pivot table

Make a copy of the pivot table, but paste only the values. Now you can make a bubble chart.

option 2 - The pivot table values may change, but the dimension would stay the same.

make a copy of the pivot table, but put in each cell a reference to the corresponding cell (e.g. =E15 ) in the original pivot table. Now you can make a bubble chart.

edit:

option 3 - Everything needs to stay dynamic

  • Use a pivot chart instead of a pivot table. see here.
  • Its also possible to convert your existing table into a pivot chart. see here.

edit 2: option 3 seems not to work for bubble charts after all. I leave this option here for completeness’ sake.

Upvotes: 1

Related Questions