Results 1 to 3 of 3

Extracting user-driven monthly data into a Graph: MATCH, INDEX, etc

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Victoria
    MS-Off Ver
    Excel 2003
    Posts
    2

    Extracting user-driven monthly data into a Graph: MATCH, INDEX, etc

    Hi all,

    I have used the search function but can't seem to find a suitable solution.

    I'm trying to figure the best way to extract 12 continuous months worth of data from a table and plot on a graph, each month with a separate plot on the graph (i.e. not the summed total but rather, a line graph with 12 points). The data is based on two, user-generated inputs, that are produced from a dropdown box.

    I can create the Data Validation rules, use a Match formula to produce the reference for an Index formula and i have created a bunch of Named Ranges to work with and can easily generate the FIRST value to plot, e.g. INDEX(DATA,ROW,COLUMN). After the first value, I'm stuck on how to generate the rest.

    I have attached my problem for reference.

    Many thanks, in advance, for any help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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