Horizontal filter with user options linked to graph??

Iamaturnip

New Member
Joined
Mar 9, 2013
Messages
1
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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,089,992
Messages
5,411,713
Members
403,394
Latest member
Mohan Kumar

This Week's Hot Topics

Top