I want to plot a column of data but need to define easily what column
to chart.
I have a worksheet called data with each column representing a year
and each row representing a day, so 365 rows. The Year is in ROW 1 and
the data is in rows 2..366
On another sheet called Charting I have A1 = to the year of data I
want to plot.
What do I need to put in A2..A366 so it pulls in the correct data
based on the year in A1?

Here are two formula you could use

=OFFSET(Sheet1!$A$1,ROW(A1),MATCH(Sheet2!$A$1,Shee t1!$B$1:$J$1))
or
=INDEX(Sheet1!$B$1:J366,ROW(),MATCH(Sheet2!$A$1,Sh eet1!$B$1:$J$1))

Where Sheet1!B1:J1 are the years, A1 has the year you want to display and
the row data runs from B1:J366, with titles on the first row. Don't forget
leap year! You adjust as appropriate for your data.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"gtslabs" wrote:

I want to plot a column of data but need to define easily what column
to chart.
I have a worksheet called data with each column representing a year
and each row representing a day, so 365 rows. The Year is in ROW 1 and
the data is in rows 2..366
On another sheet called Charting I have A1 = to the year of data I
want to plot.
What do I need to put in A2..A366 so it pulls in the correct data
based on the year in A1?