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