PopTools logo

Scale graph series

This routine has become redundant now that Excel provides bubble charts. It 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


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.

Footer image - matrix analysis