GraphIf Function?
 

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??

GraphIf Function?
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Matt" wrote in message
oups.com...
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??