Google Sheets 4 quandrant / bubble chart / magic quandrant

Here is a Magic Quadrant template in Google sheets.   If you have been looking for an easy way to create one of these bubble charts to pitch your great ideas to the execs, then look no further.  I found a few templates in Excel but they seemed overly complex.

Just give me the chart!  -->  HERE

2 sheets - one for data and one for the chart

The background of the chart is transparent so it is just using the background color of the cells to highlight the quadrants.   Use the cells to create boxes around key areas of the chart like the legend.

The data sheet is as follows:

Bubble Title:  Text highlighted over each bubble
Legend:  Defines the color of the bubble
x-Axis:  In my case I needed to add a couple values for the x Axis so you will see 2 of them and the x axis has a range of 0-10   (actually 0-11 defined on the chart to allow for padding)
y-Axis: Simple range from 0-5 (actually 0-6 defined on the chart to allow for padding)

Bubble Title	Legend	X Axis Plus	Y Axis	Bubble Size	X Axis Plus
	OK to change	OK to change	OK to change	OK to change	OK to change
Idea	Type	Traffic	STM	Confidence	Impact
Idea 1	Internal	5	5	5	5
Idea 2	Internal	2	3	3	2
Idea 3	External	5	4	4	4
Idea 4	External	2	5	5	3
Idea 5	External	1	4	4	2
Idea 6	External	2	3	3	1
Idea 7	External	2	2	2	2
Idea 8	Exec	5	1	3	3
Idea 9	Internal	2	2	4	4
Idea 10	CX	4	1	1	5
Idea 11	CX	2	2	1	4
Idea 12	CX, SEO	2	1	1	3
Idea 13	Internal	2	3	1	2

Hope this saves you some time!