I have made a chart and it is fed from a dynamic name range. The named range basically is an offset function that returns a range based on cell references with dates in. But anyway, When I apply it to my chart the series value looks like this:
=Gas_Dashboard!Gas_Spend_Dynamic
Where...
Hi there I was wondering if someone could help me understand this formula. I understand what it does and I understand what results it returns, I just dont understand HOW. Any help would be very much appreciated, ill explain what I know underneth:
So as an overview what this formula does is...