Conditional Formatting (colors) in Bubble Chart

**SASO** · 09-08-2009, 08:08 AM

Dear Community,

This is my first thread in this forum and I hope someone can help me (i attached the xls file):

I am trying to create from a table (Sheet1) a bubble chart which should represent 3 quantitative dimensions (x: Risk, y: Benefit, z (bubble size) : Budjet) and one qualitative dimension (attractiveness).
I also want the data labels to be displayed on the chart.

Attractiveness should be represented through the colors of the bubbles:
e.g. green for "high" attractiveness
yellow for "medium" attractivenss
red for "low" attractiveness.

I could achieve something but it is not exactly what I want:

I found a "VBA Conditional Formatting of Charts by Series Name"(see below). This allows to color the bubbles according to the cell color of the respective data serie.
This works fine but I have to generate manually a bubble chart (Sheet 2) with multiple series, specifying each data serie and its respective x,y,z values in the wizard (I have 250 entries!). The reason why i have to do it manually is that otherwise excel generates only a bubble chart with 1 data serie (Sheet3)!

Does anybody has a solution?

Thanks

**Andy Pope** · 09-08-2009, 08:45 AM

Create a series for each colour.

**SASO** · 09-08-2009, 12:42 PM

Thanks a lot Andy. That was actually what I was searching for!

**engineer1l** · 11-27-2011, 08:15 PM

Works Great!

**almostthere2** · 12-07-2012, 01:13 PM

Very helpful Andy - thanks

**jessicazhao** · 12-09-2012, 01:58 PM

Hi -- I am trying to create conditional formatting for a bubble chart, but the relevant criteria is not in the x axis, y axis or size of the bubble. That is, I believe the solutions proposed above are only relevant if the formatting is conditional upon one of the critical inputs to making the graph, whereas my formatting should be conditional upon another input.

How do I go about doing this?

Thanks!

**Pepe Le Mokko** · 12-09-2012, 03:14 PM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**Den123** · 12-24-2015, 12:23 PM

Originally Posted by Andy Pope

Create a series for each colour.

Hi Andy, very helpful!

How do you add as well the labels A, I, U on the bubbles?

Thanks, Den

**FDibbins** · 12-24-2015, 12:25 PM

Den, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.