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

**Muppett** · 01-14-2013, 03:04 AM

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.

**benishiryo** · 01-14-2013, 03:27 AM

hi Muppett, welcome to the forum. it would be good to show a desired outcome too. guessing that you just need the 12 months of costs, then in D2:
=INDEX(Data,$C$2,$C$4+COLUMNS($D2:D2)-1)