Use Same Table of Data For Multiple Charts, Allow Sorting Without Affecting Charts

[ThePianoman]

Using: Microsoft Excel 2010

I have run into a pesky little problem when charting a set of data that I need to sort multiple times. I have a set of clinical patient data, that resembles the data below. I need to chart Test 1 Results, but separate charts for different groups of patients. For example, I need one chart with Test 1 Results for Type of Disease= 1 patients, one for Type of Disease= 2 patients, and so on. I have a lot more data than what is below, and I need to group the data like this (by sorting it) in MANY different ways. Obviously this means copying the table over and over and over again, and re-sorting it. What I need to know is, is there a way to use only one set of data to create all of these charts, so that when I sort the data in the table it doesn't change the previously created charts? I understand that the data is graphed based on a range, so isn't it possible to force Excel 2010 to reference the specific values instead of generically referencing a cell where the value of that cell could potentially change when you sort the data? I've searched all over for answers to this, and have had no luck thus far.

Study ID	Gender	Type of Disease	Number of Genes	Date of test	Visit Type	Visit Number	Test 1 Results
3	Male	3	2	7/28/2000	S	1	13
3	Male	1	2	8/28/2000	S	2	14
4	Female	2	3	9/1/2000	S	1	15
4	Female	1	3	8/17/2001	S	3	16
7	Female	2	2	11/17/2000	S	1	17
7	Female	2	2	8/10/2001	S	2	18
7	Female	2	4	4/16/2002	S	3	19
7	Female	1	2	11/12/2002	S	4	20
7	Female	3	2	9/19/2003	S	6	21
7	Female	3	2	12/16/2003	V	1	22
7	Female	2	2	5/26/2004	V	1	23
7	Female	1	2	3/16/2004	V	2	24
9	Female	3	2	2/2/2001	S	1	25
9	Female	2	2	4/17/2001	S	2	26
10	Female	1	4	4/13/2001	S	1	27
10	Female	1	4	6/13/2001	S	2	28
15	Male	2	2	8/1/2001	S	1	29
15	Male	3	2	9/25/2001	S	2	30
16	Male	2	2	12/19/2001	S	1	31
16	Male	1	3	7/18/2002	S	2	32
16	Male	1	3	6/12/2003	S	3	33
20	Male	1	2	2/14/2002	S	1	34
20	Male	2	2	3/8/2002	S	2	35
26	Female	2	3	4/4/2002	S	1	36
28	Male	1	2	4/23/2002	S	1	37
28	Male	3	2	9/23/2003	S	2	38

<colgroup><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>