Friday, July 21, 2017

Excel Sheets 4 quandrant / bubble chart / magic quandrant

After posting how to create a magic quadrant in Google sheets, I figured I might as well create a simple one in Excel as well.

For Google Sheets look here:
Google Sheets Magic Quandrant

Here is how the chart looks in Excel



The major difference between Excel and Google was that I could only get 4 dimensions into Excel while I was able to get 5 dimensions in the Google sheet chart.

Note here that the legend has the same values as the titles on each of the bubbles.   In Google Sheets I was able to add a category to group bubbles by color.

Download the Magic Quadrant Excel Template --> HERE

No comments:

Post a Comment