Hi
I am trying to follow this example where I use the Offset function to build a dynamic chart, however I can't even get past the OFFSET funtion!
It keeps returning a #VALUE! error and when I look at the function the result is volatile.
The data range I am referring to is not updated by a user, but by a formula range that is referring to another place that is being updated and will either get bigger or smaller depending on what criteria the user is entering on the input page.
I based by formulas on this example that I had seen in a few places, including here: http://chandoo.org/wp/2009/10/15/dyn...t-data-series/
However I used Countif instead of CountaA because my first column is names and even when it is not showing "data" the cells have formulas that refer somewhere else. (if they meet the criteria, they show the result, otherwise it's "").
Even when I just try a regular OFFSET formula I get a volatile result??
What am I doing wrong? I am using Excel 2010.
I'm so frustrated!!!
Bookmarks