• 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.

2x2 charts

J

jagmohan

New Member
Hi,


Any idea on plotting a 2x2 chart with area of circles in each quadrant proportional to data point.


regards,


Jagmohan
 
Do you mean a 2 row x 2 Col chart with a circle in each quadrant proportional to a value?

Can't you use a Bubble chart for that ?
 
Hi Hui,


Bubble charts can not be combined with other chart types :-( Besides they do not have 2x2 property. e.g. I can not mark the axis with "low", "high" kind of lables.


And hence call for help!


regards,


Jagmohan
 
Can you explain or point us to what you mean by a 2x2 property ?


With a Bubble you assign values to your data say in this case


P1 x=5, Y=5

P2 x=5, Y=10

P3 x=10, Y=5

P4 x=10, Y=10


scale the X & Y axis from 0 to 20

delete the axis

Add text boxes to suit for your titles
 
Hi,


Unfortunately, I dont think I can attach a file to mail or copy paste a picture here in the posting and hence cant show you the kind of chart I am looking for. But let me try to explain.


1. Let's say I am trying to evaluate my projects based on 2 parameters - complexity (high Vs low) and market segment (generic Vs customized)

2. That gives me 4 combinations - low complexity+generic segment; low complexity+customized segment; high complexity+generic segment; high complexity+customized segment

3. I can represent these 2 parameters (2 axis) and these 4 combinations on a 2x2 matrix

4. Each project has a different cost.

5. Based on which combination each project falls in, I can draw a circle (bubble) proportional to the cost in the quadrant that corresponds to this project.


This will help the management to take a decision on prioritizing the projects.


I wish I could have attached the excel sheet here.


regards,


Jagmohan
 
Did you try what i suggested above ?


Have a look at a mock up here: https://rapidshare.com/files/937077438/Bubble.xlsx
 
Hi Hui,


More or less that is what I need. But more precisely the chart in attached file is what I need. (I have hand drawn it and it is not using excel chart!)


https://docs.google.com/leaf?id=0B3q8UMRZP1IGZjNkYzljM2EtNmFiNi00M2FhLWJlOWQtN2U2MWQzMDBmZGYx&hl=en_US&authkey=CPL2goAO


regards,


Jagmohan
 
Jagmohan

So add more series to the chart I supplied

position X & Y values and sizes as appropriate
 
You must log in or register to reply here.
Back
Top