Representing same data points in a scatter plot

**Chandelia** · 12-02-2009, 04:31 PM

I have two data sets that I want to plot on a scatter plot which share some of the same data points (e.g., both have [1,1]). Right now, when I plot the graph, I see only a single dot for [1,1], making it seem like there is only one data point there. I want to be able to show somehow that there are two data points there, such as by making the size of the dot dependent on how many data points are in it.

Is there a way to do this with Excel?

Thanks!
Chand

**sweep** · 12-02-2009, 05:09 PM

Hi,

I'm not sure if this feature is available in the Mac version, but:

Select each of the data series in turn, and select format data series. In the marker options, select solid fill, and then increase the transparency to over 50%. You should then be able to see one series "through" the other.