Google-sheets – Cannot create pie chart in which all values are identical

If a particular answer was never submitted, then the sheet simply doesn't know about it. The form can display those options, using the information from the form itself. But the sheet only has the responses from the form.

Here is how you can make a chart with those missing things.

1. You will need to make a full list of options yourself: either type or copy-paste them. This can be done at the same time as creating the form.

2. Against each option (say, cell F2), put the formula countif(B2:B, F2), assuming the responses are in column B. This will count the number of responses for that option.

3. You now have a small summary table; create a bar chart from it.

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