If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|