I'm trying to create a chart that has a dynamic domain of X-axis values using a nested IF function IF("","",IF(max-value,"",formula)).
See cell B16 in the attached file for the actual IF function.
The red series charts the X-values in B15 to B47 against the Y-values in E15 to E47.
The red series is good.
The blue series charts the same values as the red series plus one additional "blank" row, row 48, (which isn't actually "blank" but contains the nested IF function.)
The blue series is wrong.
It uses the position in the list (1 2 3 4 5....33) as the X-values for the blue series rather than the X-values from B15 to B48.
What am I doing wrong?
Graph problem.JPG
Bookmarks