This question is for Google Sheets. I'm asking two questions in one post, both are related to the same thing.
Is there a way we can use formulas like in the picture below, to achieve the results, instead of hardcoding the ranges in the charts setup?
It is also crossposted here, no answers so far: Can we make charts dynamic using formulas (INDEX MATCH and MAX) - Google Docs Editors Community
Is there a way we can use formulas like in the picture below, to achieve the results, instead of hardcoding the ranges in the charts setup?
It is also crossposted here, no answers so far: Can we make charts dynamic using formulas (INDEX MATCH and MAX) - Google Docs Editors Community