How to count data points in scatter chart

[Kumar Shanmugam]

How to count data points in scatter chart

 

[Hui]

I'd suggest counting the data points in the source of the data

Can you post a sample file to illustrate what you are trying to achieve?

You may wish to look at using Countif/s
http://chandoo.org/wp/2010/04/20/introduction-to-excel-sumifs-formula/

 

[Kumar Shanmugam]

Hi You are right, I did it by using countif. but I used bubble chart as it provides more space to accommodate count values of X and Y scatter plot (X,Y).

For eg: X=5 and Y=1 and no of occurences is 5 then my data label should be 5.

Now I want to highlight some data cells based on value provided in the sample data. Please refer the attached sample file.

 

[Kumar Shanmugam]

Sorry Hi I wanted to highlight data labels in chart.

 

[Hui]

Do you mean like this?

Simply add 3 series and plot separately
see attached file: