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.

[TABLE="width: 733"]
<colgroup><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Study ID[/TD]
[TD]Gender[/TD]
[TD]Type of Disease[/TD]
[TD]Number of Genes[/TD]
[TD]Date of test[/TD]
[TD]Visit Type[/TD]
[TD]Visit Number[/TD]
[TD]Test 1 Results
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Male[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]7/28/2000[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Male[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]8/28/2000[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Female[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]9/1/2000[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Female[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]8/17/2001[/TD]
[TD]S[/TD]
[TD]3[/TD]
[TD]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]11/17/2000[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]8/10/2001[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]4/16/2002[/TD]
[TD]S[/TD]
[TD]3[/TD]
[TD]19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]11/12/2002[/TD]
[TD]S[/TD]
[TD]4[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]9/19/2003[/TD]
[TD]S[/TD]
[TD]6[/TD]
[TD]21[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]12/16/2003[/TD]
[TD]V[/TD]
[TD]1[/TD]
[TD]22[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]5/26/2004[/TD]
[TD]V[/TD]
[TD]1[/TD]
[TD]23[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Female[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3/16/2004[/TD]
[TD]V[/TD]
[TD]2[/TD]
[TD]24[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Female[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]2/2/2001[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Female[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]4/17/2001[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]26[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Female[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]4/13/2001[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]27[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Female[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]6/13/2001[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]28[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Male[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]8/1/2001[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]29[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Male[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]9/25/2001[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Male[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]12/19/2001[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]31[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Male[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]7/18/2002[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]32[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Male[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]6/12/2003[/TD]
[TD]S[/TD]
[TD]3[/TD]
[TD]33[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Male[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2/14/2002[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]34[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Male[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]3/8/2002[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]Female[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4/4/2002[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]36[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]Male[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4/23/2002[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]37[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]Male[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]9/23/2003[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]38
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]