4 Replies Latest reply: Mar 13, 2013 8:20 AM by Chintal (Shah) Modi RSS

    Bubble Chart To Aid the Capital Budgetting Process

      Hello,

      I have been tasked to create a bubble chart that allows senior management to make strategic decisions as part of the capital budgetting process.  As an FYI, currently the data for capital budgetting is married with project or idea data from Clarity on a spreadsheet and then fed into QlikView.  We are in the beginning of the process where we are not yet collecting all the data elements we need. So I have created some fictitious data to create my bubble chart.

       

      My Boss would like me to plot business category (strategic/patient saftety etc.) on the Y Axis, Risk Score on the X axis, and the size of the bubble, Z, is Planned Effort in hours.  He would like the color of the bubble to be the cost.

       

      My first question: After reading up on some information on Bubble charts and how they are created in Excel, am i limited to only three data points?  X, Y, and Z.  If not, i'm not sure how to represent cost as color. 

       

      My second question:  In a simple bar chart or pie chart, i'm usually ok with expressions, however, i'm not sure what the expression should be here.  For now, i just put 1=1.

       

      My last question for now: I have set Z (planned effort in hours) to be different values so i'm not sure what i'm missing and why my bubble is the same sizes.

       

      Thank you in advance for your help.

      Bubble chart.jpg