I've created two large historical tables on separate sheets. The master sheet (Bins) contains the following columns:
Year - Side - Commodity - Variety - Block and then each consecutive column is a day of the year, starting at 4/26 and going through 10/31 (F - GL). Column GM is a sum of all days in each row. For example, GM15 totals F15:GL15. The second sheet (Percentages) is identical to the first in size and format, however, it calculates daily percentages of totals from the first sheet. For example, cell BA15 contains the formulato provide what percentage that day was of the total line.![]()
=Bins!BA15/Bins!GM15
These are very large tables (1400 rows x 195 columns), and will only grow larger as time goes on and new years are added historically. I need to graph this data based on the way the table is filtered. For example, if I want to see a graph of all 2004, east side, peach, peach type 1, is there a way to use the Data filters and have a graph automatically pick up my filtering choices and plot them?
Also, is it possible to have a set of input cells that a graph calls to which then applies what is input as filters to the data table and formats them? For example, on a sheet with only the graphs and one row for input, can I input "2004" "East" "Peach" "Peach Type 1", and have it automatically pull only that data from the table and plot it?
Bookmarks