Pie Bubble Chart

Figure 10.22 shows a pie bubble chart. A bubble chart is like a scatter (XY) chart with a third data series that is represented by the size of the bubble. The chart you see here is an extension of the bubble chart concept where a fourth parameter (the breakup of each bubble) is shown with the bubble depicted as a pie chart. This is done by having VBA loop through the number of points in the data series, and for each point, update a (hidden) pie chart with the corresponding value and paste a picture of the pie chart in place of the bubble for the point.data series.

0 0

Post a comment