Pete Mccann
Member
Hi Chandoo colleagues. I'm attaching a file with a bubble chart (which I think is appropriate for a certain application we're working on) but I would like to do some modifications to it without using VBA (if at all possible).
I think a lot of what I'm looking for is in the formatting of the chart. There are a set of "Locations" and "Values". I've partitioned these values into certain ranges (although the partitioned values are not actually plotted). I've also "randomised" the values to see if the chart responds.
So, if possible, I'd like to do the following:
1. Can we have the labels "A" to "G" on the horizontal axis?
2. Can we make the sizes of the bubbles equivalent to the sizes of the data values (big numbers = bigger bubbles). It would be good to "display" a zero (or negative value) bubble somehow.
3. Can we have coloured ranges (horizontal bands) on the chart equivalent to the "steps" in D2:G4. If the Step Values change (i.e. different ranges are being analysed) then the coloured bands on the chart should reflect the break points.
4. Can we have the bubbles coloured according to the ranges that they are in (i.e. if a bubble is between 020, then the bubble is red?)
I appreciate that this is a lot to ask for, but I'd be grateful for some guidance on this.
Many thanks in advance.
I think a lot of what I'm looking for is in the formatting of the chart. There are a set of "Locations" and "Values". I've partitioned these values into certain ranges (although the partitioned values are not actually plotted). I've also "randomised" the values to see if the chart responds.
So, if possible, I'd like to do the following:
1. Can we have the labels "A" to "G" on the horizontal axis?
2. Can we make the sizes of the bubbles equivalent to the sizes of the data values (big numbers = bigger bubbles). It would be good to "display" a zero (or negative value) bubble somehow.
3. Can we have coloured ranges (horizontal bands) on the chart equivalent to the "steps" in D2:G4. If the Step Values change (i.e. different ranges are being analysed) then the coloured bands on the chart should reflect the break points.
4. Can we have the bubbles coloured according to the ranges that they are in (i.e. if a bubble is between 020, then the bubble is red?)
I appreciate that this is a lot to ask for, but I'd be grateful for some guidance on this.
Many thanks in advance.
Attachments

19.2 KB Views: 6