Okay: 2 sheets
sheet1: called Nationality
Sheet2: called Graph

Sheet 1 consists of a table. Column A4:20 is various nationalities.
Columns B3-M3 are months of the year, with column B starting with JUL
Under Month are various percentages corresponding to nationalities for that
Month.
Cell I1: named MONTH. format of cell is general. Cell K1 is a date. Any
date can be entered, such as Dec 05.
at the bottom of this page is a graph reflecting nationailies, and the graph
changes DEPENDING on the date entered in K1

Sheet 2: has a table
A4: A20 are nationalities
B3: cell is named PERIOD and C3: cell is named YTD for the graph
Formula in B4 is
=VLOOKUP(1,Nationality!B4:M4, IF(MONTH(date)6,MONTH(date)-6,MONTH(date)+6))
under column YTD formula is simply = nationality!O4
Could just copy and use this existing Graph. My problem is that my year
commences in JUNE and not July and if I merely change Column B3 to June it no
longer registers.
Does this explain in more detail. I have tried to check everywhere to see
if there is a formula I am missing.



"Harlan Grove" wrote:

Ali wrote...
You need to see the existing graph to figure out why and how it is working.
Could I e-mail it to you?

As I see it, your formula as written can't work. If you're getting
anything useful out of your worksheet, it'd have to come from other
formulas in other cells. Why not just show those other formulas?