Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jun 2007
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good afternoon ..... the problem is to map two bubbles automatically into a Boston Risk Matrix and show the bubbles to be proporational in size according to the confidence interval associated with the degree of certainty in the "score" ........ as follows:


    .. X..............Y..........Score.......Confidence
    .............................( X * Y ).......Interval

    3.79...........3.48.......13.2............0.29
    3.01...........2.75.........8.3............0.20


    The Boston Risk Matrix in the sheet attached is heavily annotated, as I was not able to work out how to produce the bubbles on the same chart as the bars producing the colored areas Red, Yellow, and Green. I am also at a loss to add in the grid lines. In addition, I am not getting how to add the numbers at both the matrix intersections points (the product of the x and y indices) and the bubble centers (the score value).

    Thank you for your kind assitance and support. By the way, what happend to the lounge lizard? He(?) is missed .... !
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Lex is still alive but, as Bowlie says, "otherwise engaged". See Lexes from the old lounge


  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can't create a combination chart that includes bubble series.

    You could create a bubble chart based on the data you need, give it a transparent background, set its axes to go from 0.5 to 5.5 and overlay it on the area chart. But it's tricky to get the chart areas to match exactly.

  4. #4
    Lounger
    Join Date
    Jun 2007
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='786107' date='24-Jul-2009 16:28']You can't create a combination chart that includes bubble series.

    You could create a bubble chart based on the data you need, give it a transparent background, set its axes to go from 0.5 to 5.5 and overlay it on the area chart. But it's tricky to get the chart areas to match exactly.[/quote]
    Thank you Hans. I had a feeling that this was the case. This presentation will eventually appear in an automated Integrated Performance Monitoring system built on a Business Objects platform; so in the end it will be the tech folks who sort out out the presentation details. As the SME on the project, I direct content and algorythm development, and when possible, actually demonstrate a functioning prototype proving all steps and processes through to presentaion. However, in this case, the prototype will have to remain a little more primtive than usual.

    So when the lizard is done basking in the sunshine on his extended vacation, I am looking forward to his reappearance in his usual postion, monitoring and commenting (so to speak) on user bahavior.

    ...........

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How about something like this?

    I combined a Area Chart with an XY scatter. The Current and proposed are not filled but they are the correct sizes and will adjust. (They are just a drawn circle with XY points). It could be approx filled (if really desired) by using lines to create a Hatch pattern in the circle (one could be hoiz the other vertical, or one hor+Vert the other at 45 degrees both directions).

    Since the area covers the auto gridlines of the chart, I added some on the XY coords...

    Steve
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •