Christopher Turnbull
Reputation: 1005
Use a Dynamic Range for Chart Google Sheets
Is there any way to do this other than using an API?
It seems like you can't specify the range of a chart with a formula.
I've tried name ranges too - does anyone know a work around?
Upvotes: 1
Views: 1243
Answers (1)
player0
Reputation: 1
unfortunately this one is not possible. google sheets (up to this date) does not support formulas in input field of charts. the only thing you can do is to query/filter your dataset on some separate hidden sheet and then construct chart from there.
Upvotes: 1
Related Questions
- Update chart range with dynamic range
- VBA for Dynamic Chart Data with N/A or Dynamic Range
- Passing a dynamic range to charts
- How to have changing range in Google Sheet graph
- Chart from dynamic range
- Dynamic chart formula
- VBA in Excel: Controlling a Chart with Dynamic Ranges
- Set Excel chart data series range dynamically by a cell's value
- dynamic data range for vba chart
- Dynamic Range with Categorical Variables