Hack Bubble Charts to Create Proportional Shapes
Fellow Microsoft MVP Glenna Shaw and I recorded this quick tip last year on the Microsoft campus for their Channel 9 series.Subscribers to my newsletter have access to a custom Excel tool to calculate size of proportional shapes, but you can let Microsoft do all the work for you by starting with a bubble chart and then breaking it apart. Take a look!