No idea how to accomplish this but I would like a chart to adjust when new data is added
The problem is because the chart covers cells that are blank this causes issues
The chart would be looking at 2 columns
Column A being time
Column b being a number
Vacant rows on these columns are populated by a trigger event so a time is grabbed for column A and a number for column B
The duration can go from minutes until 8 hours
I’m wondering whether their should be grouped times so the graph is not too messy with vast data
Ultimately I want to see a line that would go up or down over time
The problem is because the chart covers cells that are blank this causes issues
The chart would be looking at 2 columns
Column A being time
Column b being a number
Vacant rows on these columns are populated by a trigger event so a time is grabbed for column A and a number for column B
The duration can go from minutes until 8 hours
I’m wondering whether their should be grouped times so the graph is not too messy with vast data
Ultimately I want to see a line that would go up or down over time