sunbursts

  • Thread starter Thread starter Stevethedoc
  • Start date Start date
S

Stevethedoc

now i plot scattercharts, but need plots to be bigger if more than on
piece of data is represented by it. friend suggested that concept i
called expanding sunbursts or something similar, any chance of som
help
 
You could add a couple of columns to your data, and create a column
chart. For example, if your values are in cells A2:B50 --

In D2, enter a formula to concatenate the values: =A2&"-"&B2
In C2, enter a formula to count the occurrences of each combination:
=COUNTIF($D$2:$D$50,D2)

Copy the formulas down to the last row of data

Select columns A:C and create a bubble chart.
 
Back
Top