I have some charts (attached file) that read a table. The first one is the most basic -- all of the rows. The others display a subset of the data (based on criteria in the first column). The cells were selected manually, so the results are unsorted. That doesn't work (and the data will not always be in that position so cells have to be selected manually every time).
The goal is to have each chart with bars sorted, reading the table, with the correct rows selected (for East, West, South, etc).
The only method I can think of is to create a separate table for each chart, with each table having the correct data, sorted separately. That does work. But if there were 15 charts, that would be 15 tables -- all extracting subsets from the same data.
Is it possible to feed a query result to each chart with an IF statement of some kind?
SELECT Operation, 2009 YTD WHERE Region = "East"
I have tried a VLOOKUP, which also would require separate rows of data for each chart -- but I couldn't get that to work either.