googlegoogle sheetsgoogle-sheets-charts
I have a google form linked to a google sheet (so every time somenone fills the form, a new row is created). I would like to make a chart that count the number of rows each day. In the example shown below, I would like the first bar to have a height of 3, the second 6, then constant until 03/05/2020 where it goes to 16 and so on… Does anyone have a solution for this?
Thank you!
Stepped area chart does not support variable width of steps. But you can use the ordinary area chart like this:
The data provided to this chart was as follows. The first column was marked for "use as labels" when inserting the chart.
0.00 0
1.00 0
1.00 1
1.41 1
1.41 2
1.73 2
1.73 3
2.00 3
2.00 4
2.24 4
2.24 5
2.45 5
2.45 6
2.65 6
2.65 7
2.83 7
The idea is that each x value is repeated twice, and each y value is repeated twice, but they are half-step out of sync with each other. So every time we move down the rows, exactly one of two coordinates changes: x (horizontal segment) or y (vertical segment).
For the record, the formulas were =sqrt(floor(row()/2)) and =floor((row()-1)/2) and the chart options were
Sort the source data as shown in the following snapshot:
Best Answer
You can use a query like this :
Result :
Graph :
