I would like to add a yellow outline to a bubble if any of the three values used to create it are between 50-75. This will be a bubble chart with several slicers so the need for a yellow outline will be a moving target. Any way I can achieve this?
My data set up (from a pivot) looks like the below. I'm happy reference the data to be outside of the pivot table if need be. If the answer is VBA, can you please provide code as I am just starting to try to learn VBA. Thank you so much in advance!
My data set up (from a pivot) looks like the below. I'm happy reference the data to be outside of the pivot table if need be. If the answer is VBA, can you please provide code as I am just starting to try to learn VBA. Thank you so much in advance!
Product | Bubble Size | Y Axis | X Axis | Bubble Size Sample | Y Axis Sample | X Axis Sample |
A | 0.34 | 2.28 | 4.07 | 371 | 371 | 371 |
B | 0.47 | 2.48 | 5.73 | 129 | 129 | 129 |
C | 0.43 | 2.34 | 4.73 | 67 | 67 | 67 |
D | 0.57 | 2.54 | 5.81 | 54 | 54 | 54 |
E | 0.65 | 2.49 | 5.68 | 184 | 184 | 184 |
F | 0.54 | 2.41 | 4.92 | 241 | 241 | 241 |
G | 0.48 | 2.41 | 4.84 | 1712 | 1712 | 1712 |
H | 0.66 | 2.55 | 5.91 | 188 | 188 | 188 |
I | 0.53 | 2.54 | 5.69 | 118 | 118 | 118 |
J | 0.36 | 2.33 | 3.60 | 315 | 315 | 315 |