Ok I think this is simple. I created a bubble chart with info below. How do i get column A to be my legend? Risk Probablity - 1 (low) to 5 (high) Impact - 1 (low) to 5 (high) Traffic Light Risk management strategy Lack of capacity or competence local reources 4.0 4.2 17 Mitigate Availability of resources from Global Team 3.0 3.0 9 Mitigate Availability of Consulting Team 2.0 4.0 8 Mitigate Master Data Accuracy/Completness 4.0 4.6 18 Mitigate CodeIT Interface 2.0 4.0 8 Mitigate EDI interface 1.0 1.0 1 Mitigate Qlik data reporting 2.0 3.0 6 Cutover plan prepardness 4.0 4.0 16 Go Live support 4.0 4.5 18 Hardware resource issue: Slow performance or failure. 2.0 3.0 6 Mitigate

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Bubble Chart legend

Ok I think this is simple.

I created a bubble chart with info below.
How do i get column A to be my legend?

Risk	Probablity - 1 (low) to 5 (high)	Impact - 1 (low) to 5 (high)	Traffic Light	Risk management strategy
Lack of capacity or competence local reources	4.0	4.2	17	Mitigate
Availability of resources from Global Team	3.0	3.0	9	Mitigate
Availability of Consulting Team	2.0	4.0	8	Mitigate
Master Data Accuracy/Completness	4.0	4.6	18	Mitigate
CodeIT Interface	2.0	4.0	8	Mitigate
EDI interface	1.0	1.0	1	Mitigate
Qlik data reporting	2.0	3.0	6
Cutover plan prepardness	4.0	4.0	16
Go Live support	4.0	4.5	18
Hardware resource issue: Slow performance or failure.	2.0	3.0	6	Mitigate