Excel Video 501 Power View Bubble Charts

A Bubble Chart is another chart that’s available in Power View. While Excel has added the ability to create a Bubble Chart in standard Excel, there are features worth exploring in Power View. Watch how to create a Bubble Chart by setting the x and y axes and then controlling the size of the bubbles. Bubble charts are an interesting way to show three variables at once. Note that in the video I put the provider field in the Details area of the chart. If I put the provider field in the Color area of the chart, it looks more like a traditional legend you’re used to seeing.

Speaking of interesting, stay tuned. We’ll add a fourth variable to the chart and animate the chart at the same time. I’ll bet you haven’t seen an Excel chart do this before. You’ll see animated Bubble Charts in the new Excel Video. Thanks for watching.

Finally, the contest celebrating 500 Excel Videos ends on March 31. Be sure to enter the contest associated with 500 Excel Videos to win a free CMS Referral Data Analysis. You probably know who is sending patients to your practice. The interesting question is who is sending patients to your competition. Win a free CMS Referral Data Analysis and find out.