Make business 'Sense' with Bubble Charts

If you are to present the four parameters say Brands,Growth,Market Share and Sales,on a graph to understand dynamics of the market,   a 'Bubble Chart' can easily show these four parameters on a single graph
We know X and Y Axis can show two data points. 
The third one is the size of the point in the form of a Bubble and 
The forth one is Color to distinguish between data points.
So, in a Bubble chart, Parameters can be shown
Bubble Chart Example : You can download the Template from Link given below
  • Parameter 1: Brands can be shown in Color
  • Parameter 2: Growth can be shown on X Axis
  • Parameter 3: Market Share can be shown on Y Axis
  • Parameter 4: Sales can be shown as Size of a bubble 
One can easily create Bubble charts using excel. However, when you are plotting multiple series of data points (Here in the example quoted above, it is the Region)you need to pain strikingly input each data point on the chart.
To make things easier, create a template and use the template everytime.
I have created one such template for you. Next time when are are to create a bubble chart, just use the template! 
You can download the excel file @Downloads
It's a DO..CO..MO.. stuff (Download, Copy , Modify )

3 comments:

  1. Learning,Contributing and Developing is the three fact to grow up in any organisation.


    http://www.graphs.net

    ReplyDelete
  2. It’s a classic great for me to go to this blog site, it offers helpful suggestions.
    Business templates | Excel templates

    ReplyDelete
  3. Super helpful template that with only a few adjustments saved me tremendous time, looks great and is really valuable in all aspects. Thanks

    ReplyDelete