Do I need a macro to make this scatterplot?

[clockhart10]

Hi all,

I am trying to create a scatter plot from a data set. I want to find a formula such that I can get the exact data I need.

I have a column of names, and a column of data. I want to create three data series. I want a formula so that excel will look through a column of data and find values greater than 0, THEN look at another column and if the name = the value in the cell, then it will plot that value as the x-axis value. I then want to do the same for the y-axis (using different columns).

I was tinkering with IF and AND functions, but couldn't quite get it. The name column actually contains an identifier, so ideally, the scatterplot would plot all non-zero values of each identifier (three different ones) when I put in the three data series.

This isn't what the formula will look like, but this is the idea.... =IF([data column]>0 AND [name column="Name"], then return the data in the data column)

Is this possible? I want it to find all non-zero values, and if it has a certain name, then I want it to plot each data value on the scatterplot. I don't know if I need a Macro to achieve what I want (if so, I assume I'd need to create the graph from scratch in VBA).

[GC Excel]

Maybe with SUMPRODUCT formula ?
but without seeing your workbook, it is difficult to give a better answer.

[shg]

You might take a few minutes to read (in the forum rules) how to get your questions answered quickly.