This routine scales data points of a series according to the values of a data range. The output looks like a bubble chart, but can be used on X-Y plots. (Note: It cannot set the size of the data point to less than 2 points or more than 72.)
For example, if you have XY data that looks like this
| X | Y | N points |
|---|---|---|
| 1 | 0.948 | 10 |
| 2 | 0.653 | 6 |
| 3 | 0.512 | 15 |
| 4 | 0.513 | 3 |
you could use the routine to generate the following chart in which the size of each point reflects the value of "N points".
Note: the point sizes are not updated if the graph or source changes. You will need to run the routine every time a change is made.