Circle around Datapoints in Scatterplot

**Murellus** · 01-23-2013, 04:14 PM

Hi!

I have many datapoints in a scatterplot diagram. I need to plot a circle that has a radius of 2.5 units around each datapoint. Is there any way I can do this on Excel?

**MrShorty** · 01-23-2013, 04:47 PM

1st thought is to see if a bubble plot will work for you. You will probably have to tinker with the "z value" for each data point to figure out what value of z will give you an appropriate sized circle.

**biocidej** · 01-23-2013, 04:57 PM

You might also try changing the marker to a circle with a blank fill and working with the marker size so that it becomes the size you want.

**Murellus** · 01-24-2013, 12:01 AM

Originally Posted by MrShorty

1st thought is to see if a bubble plot will work for you. You will probably have to tinker with the "z value" for each data point to figure out what value of z will give you an appropriate sized circle.

Do you mean the 'Series bubble size'?