Results 1 to 3 of 3

Varying Graph from Filtering Data

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2008
    Posts
    44

    Varying Graph from Filtering Data

    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 formula
    =Bins!BA15/Bins!GM15
    to provide what percentage that day was of the total line.

    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?
    Last edited by cjsec9; 10-15-2008 at 05:07 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. graph from auto changing data
    By drumer979 in forum Excel General
    Replies: 1
    Last Post: 05-11-2008, 07:24 AM
  2. Problems filtering data containing checkboxes???
    By nameyers in forum Excel General
    Replies: 1
    Last Post: 10-18-2007, 02:48 PM
  3. w/ Line graph with time on X and missing data
    By matlack in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-17-2007, 11:49 AM
  4. Filtering data for dropdown box
    By irish1two3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2007, 08:07 AM
  5. delete source data retain graph
    By OFFSIHR in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-13-2006, 08:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1