pulling data from different charts

[rismr]

Hi, i have a spreadsheet that is composed of multiple individual sheets. i want to make a graph of some of the data but want to include different individual sheets at a time. is there a way to do this?

for example, two individual sheets may read as

a: 1 a: 1
b: 5 b: 2
c: 3 c: 2
d: 5 d: 3

and i only want to use the data from all sheets that have 5 in the 'b' slot. I then want to be able to quickly and easily switch the viewing to all sheets that have 2 in the 'b' slot. is this possible?

[Chance2]

I think this can be done with named ranges for your graph references.
It would be easier to show if you posted an example, however, if you add a named reference something like:

=CHOOSE(Sheet1!$B$1,Sheet1!$A$1:$A$,Sheet2!$A$1:$A$,Sheet3!$A$1:$A$)

This would choose a number (in this case 1-3) in B1 and reference a range on a different sheet. Like I said, an actual example would make it easier to give a solution.

[rismr]

I may have been a little unclear in my original description. I dont actually have each sheet separated on different tabs. instead, i have it all on sheet one, just in different boxes. attached is kind of what i am working on, although i have to delete a lot of data because it is data from a hospital. In this specific case, I want to be able to pull different data depending on someone's race/ethnicity. For example, I want to use all data for people that are asian one time, then switch it later to people that are of african descent. i then want to use the combined data for one group to make a graph, and be able to switch between the different groups to compare the different graphs with ease. hope this helps

[rismr]

would this be/work easier if i had the separate tables on different spreadsheet tabs? i would prefer to keep it all on one sheet, but i don't know if what i want to do is possible.

[rismr]

does anyone have an idea on how to tackle this problem?