How to create Bubble Charts from Pivot Tables - Excel does not allow

beetelman

New Member
Joined
Nov 15, 2006
Messages
6
Hi,

Is there a way to create a bubble chart from a pivot table? The rows include names of opportunities, and I want to include the bubbles to represent Profit size of these opportunities (large profit size = large bubble) along a time horizon (horizons 1, 2 and 3). The Y axis would represent the profit size series ($) and the X axis would represent the time horizon (1, 2 or 3). Pretty simple model, but I keep getting an error message when I try to create the bubble chart from my pivot table.

In the alternative, I could create a separate sheet to just house (by dynamic link to other worksheet cells) the data I want to bubble graph on, but that seems a little clumsy. Would that be my only option?

Thanks for any help you can offer.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top