Bubble Chart - 5 variables including RAG colour

[jbridge9194]

I have a set of data that I want to present in Bubble chart format. Data would be as follows:

1. Change Name (Label) - Individual entries for each project
2. Implementation Date (X) - represented in Months (Jan-Dec 2017)
3. Impact Score (Y) Range from 5 to -5
4. Volume (Z) (size)
5. Status (Red, Amber or Green)

Therefore I would want the bubble size to be determined by no. 4, positioned accordingly on the X,Y axis and then for the bubble to be coloured according to the current project status. Each bubble would then be labelled with the Change Name.

Example data...

Change Name Status Implementation Date Impact Score Size of Impact
Change 1 Red 01/05/2017 1 1.000
Change 2 green 01/07/2017 3 0.500
Change 3 Amber 15/03/2017 -4 2.500
Change 4 Red 01/04/2017 -2 0.125
Change 5 green 12/02/2017 -1 0.680

 

[baitmaster]

The key here is that you'll need 3 ranges - Red, Amber, Green which will feed into 3 separate chart series. A simple IF statement on column 5 will put the Volumes in one of these three columns. Each chart series then looks at one of these three, along with the other applicable columns, and has a fixed colour for that series. I assume you'll be able to work out the other features easily enough