Can anyone help me to update the formulae in a graph-data-range so that I can change the range definitions according to values in other cells.
for example one cell in the graph data range contains the formula
...........(big-compare, little compare, sumif)
column B contains dates from b6 to b950
column D contains values from d6 to d950
so I am reporting on a sub section of all dates.
I can alter the value of little-compare by changing the value in cell b7
but I have failed when trying to set the anchor points of the big-compare range in the same way
I have tried experimenting with macros, but I can't help thinking that I am missinga simple way to do this
I attach a cut down example
thanks for any help.