Horizontal filter with user options linked to graph??

[Iamaturnip]

Hello,

I am a novice user of Excel.

I have a large spreadsheet relating temperatures of an "item" to %conversion of "item" at these temperatures. The columns go something like:

Temp of Item 1	% conversion item 1	Temp of Item 2	% conversion item 2
100	10	105	15
120	30	124	50
140	90	135	85
200	95	190	90

<tbody>
</tbody>

Linked to this is a scatter graph of temp Vs conversion for items 1, 2, 3.......

The problem is I now have too many "items" and it's difficult to compare on 1 graph with all the data on it.

What I want to do is filter horizontally so it only shows, for example, the data for items 1, 5 and 10. (So I pick what data is displayed). Then the scatter graph will show only, in this case, the data for items 1, 5 and 10.

From searching I've found ways to filter for 1 thing only but not multiple things (as in the tick-box thing you get with autofilter when used vertically).

I guess the answer is going to use VBA code. In this case, can you also please explain, or give a link to, how/where to copy the VBA to as I have no idea how to use it.

Thank you for your help.

J