Difference between revisions of "BUBBLE"

 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
 
'''''Bubble chart is used when we want to represent 3 sets of data in a graphical way.'''''<br>
 
'''''Bubble chart is used when we want to represent 3 sets of data in a graphical way.'''''<br>
 
'''''Out of those three data sets used to make the bubble chart, it shows two axis of the chart in a series of XY coordinates and a third set shows the data points.''''' <br>
 
'''''Out of those three data sets used to make the bubble chart, it shows two axis of the chart in a series of XY coordinates and a third set shows the data points.''''' <br>
'''''Every bubble chart in excel consists of 3 data sets. X-axis coordinate, Y-axis coordinate, and the bubble size data set.<br>
+
*'''''Every bubble chart consists of 3 data sets. X-axis coordinate, Y-axis coordinate, and the bubble size data set.<br>
''''' So with the help of X & Y axis, you can visualize a third data set through the image of bubbles.
+
*''''' So with the help of X & Y axis, you can visualize a third data set through the image of bubbles.
 
*'''''It is a X vs Y vs Z graph.'''''
 
*'''''It is a X vs Y vs Z graph.'''''
  

Latest revision as of 16:18, 2 June 2020

BUBBLE CHART

Description:

Bubble chart is used when we want to represent 3 sets of data in a graphical way.
Out of those three data sets used to make the bubble chart, it shows two axis of the chart in a series of XY coordinates and a third set shows the data points.

  • Every bubble chart consists of 3 data sets. X-axis coordinate, Y-axis coordinate, and the bubble size data set.
  • So with the help of X & Y axis, you can visualize a third data set through the image of bubbles.
  • It is a X vs Y vs Z graph.

Example

A B C D
Company Years as Company Revenues Market Cap
Apple 31 149 621
Facebook 1 4 42
Google 8 43 222
Microsoft 26 74 256
Yahoo 16 5 18

BUBBLECHART(B2:D6)

 

GRAPHING MAIN PAGE