GraphIf Function?

M

Matt

Say I have something like this:

Col A Col B Col C
A 3 5
A 5 3
A 6 7
B 8 1
B 4 6
C 6 7
C 4 2
E 7 4

Any ideas about a function such that any A would be in plotted in one
graph, any B in another graph, and so on? Is there even any sort of
GRAPH() function??
 
J

Jon Peltier

I'll make some assumptions: Col B has X values and col C has Y values, and
you want an XY chart.

I'll filter out "A" data in Col D, "B" data in Col E, etc. I only need to
filter the Y data, and I'll use the same X data for all charts.

In D1 enter this formula:

=IF(A1="A",C1,NA())

In E1 enter this one:

=IF(A1="B",C1,NA())

etc. Now fill these down as far as you have data in the table. Create your
first chart, an XY chart, and in step 2 of the wizard, click on the Series
tab. Delete all but the first series if there are more than one present, or
add one if there are none. Click in the X Values box, then select the data
in column B. Click in the Y Values box, and select the data in column D.
Click in the Name box and type A.

For the second chart, copy the first, then go to the Chart menu > Source
Data > Series tab, and change the data in the Y Values box from column D to
column E, and change the name to B.

- Jon
 
Top