ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Making a Bubble Chart with 4 variables instead of 3 (https://www.excelbanter.com/charts-charting-excel/265207-making-bubble-chart-4-variables-instead-3-a.html)

Jakote

Making a Bubble Chart with 4 variables instead of 3
 
Bubble charts allow for 3 variable (x, y, and z). Is it possible to add a
4th dimension to Excel Bubble Charts (w, x, y, and z)? What I want to do is
make a "pizza slice" in the bubble." For example if each bubble represents
an entire US industry (furniture, electronics, etc...), then I want to make a
slice in each bubble showing the size of a specific sub-section of the
industry. For example, if the whole bubble is the electronics industry, then
I want the slice to represent the percentage of the industry that is, let's
say, Sears electronics sales. Is that possible? If not, is there another
way to do it? Because I don't think I can combine chart types together.
--
Jakote

Ed Ferrero[_3_]

Making a Bubble Chart with 4 variables instead of 3
 
Take a look at my BCG Matrix chart
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx

It seems to do what you want.

Ed Ferrero
www.edferrero.com



All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com