MrExcel Publishing
Your One Stop for Excel Tips & Solutions

scatterplots


Posted by Michelle on November 03, 2000 9:10 PM

Hi

I've created a scatterplot of points x vs y. However, there are many instances when x vs y is the same and you get a number of points on top of each other, but you can't tell how many. Is there any way of symbolising this? For example colour coding the symbols according to how many ponts there are at the same location.

thankyou
Michelle



Posted by AB on November 06, 2000 9:27 AM

This is what a bubble chart is used for.