IF conditions for Graph

[Izzy13]

Hi there!

I have three columns of data ( 'Name', 'Year' and 'Marks') I want to build Year vs Marks graph, however I need it to only plot for specific names like John for example. Is it possible?

=Sheet1!$C$1:$C$6844,Sheet1!$E$1:$E$6844

This is the current formula I'm using, but it does not filter the names.

Thanks in advance!

 

[steve the fish]

Try using a pivot chart