• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SWOT analysis bubble chart?

kedenham

New Member
Hi, I want to make a cahrt in excel that visually shows the outcome of a SWOT analysis. I like the idea of using bubbles to express it in excel - but I'm struggling to translate it into an actual chart.


What I want to do is take 4 tables structured like the below information, and make the information appear in the correct quadrant of a matrix (which I can then label strengths, weaknesses, opportunities, threats using a text box) with the size of each bubble reflecting the weighting of the strength (the numbers in the right hand column below)


The main bit I'm struggling with is how to make sure they all end up in the right quadrant?


Kate


Table 1 Strengths


Strength 1 45

Strength 2 10

Strength 3 13


Table 2 Opportunities


Opp 1 12

Opp2 9

Opp3 7


Table 3 Weaknesses


Weak1 15

Weak2 6

Weak3 10


Table 4 Threats


Threat1 12

Threat2 11

Threat3 10


Any help massively appreciated!


If this is poorly explained - I want it to look like this:


http://www.business-tools-templates.com/SWOT%20Chart.jpg


Thank you for any help!!!
 

TessaES

New Member
A bubble chart requires 3 values for each point: x, y and bubble size.

So you need to add x and y values.

The chart in the picture uses size/scale as x-values and relevance/probability as y-values. If you choose negative and positive values as is done in the chart, everything should end up in the correct quadrant.

So for example Strengths uses negative x-values and positive y-values
 
Top