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
 

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,132,672
Messages
5,654,670
Members
418,147
Latest member
dorkas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top