Hi all

Chart Question.xlsx

In the attached document, I have a dynamic chart I am trying to build, that has two parameters: risk level and name, looking at fund return. I tried building an offset formula for x and y axis, but I can't get an offset to work properly when there potential blanks. eg can see in current setup, it needs pick up Fund A and Fund C, and risk levels 3, 4 and 6, without touching Fund B and risk level 5 (I don't want blanks appearing in chart).

Is there a nifty way to do this? Any help would be majorly appreciated, been wrecking my brain for a while over this and I struggled to find anything already in the forum on it.

thanks

peter