Basically, I have been working on some automated solutions to show the date and data for the most recent 4 weeks on this data sheet. There are still some bugs to work out, but the last thing I need to figure out is how to graph only the checked rows (in column i). I was aiming for a dynamic chart and my idea as of now is find some sort of formula combination to add the data from columns D-G
into a separate chunk of cells below somewhere (only if column i
is checked). Then I would have a graph that is already configured to graph the information in that range. However, I can't seem to find a way to do this. Thank you in advance and if there is a better way to do this, as long as it works, then that's perfect.
Google-sheets – If checked, add row to data chart
data validationformulasgoogle sheetsgoogle-sheets-data-validation
Related Topic
- Google Sheets – Chart with Steps of Constant Height Change, Variable Width
- Formula to Return a Cell Name in Google Sheets
- Google Sheets – How to Skip Columns in a Google Spreadsheets Chart
- Google-sheets – How to group certain data in a chart in Google Sheets
- Google-sheets – Comparison Column Chart
- Google Sheets Charts – How to Color or Group Same Kind of Data
- Google Sheets – Average a Row from Last 10 Days to Current Date
Best Answer
IF()
statement: