Friday, February 26, 2016

Plot Bubble plot using excel 2013

This is a way to address data of three dimensions, like heatmap or surface plot
But the sizes of bubbles instead of color/Z axis indicate the value you want to show over a 2D grid.



Insert -> In the charts area, click the scatter, choose bubble

Then select data. And then type in X value, Y value and Bubble size

In the example above, I set each datapoint to be an individual data series. So their colors look different

No comments:

Post a Comment