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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question