I am unable to create a pie chart in which all responses are identical, or, in other words, in which 100% of the responses are represented by a single value. When I try to create such a chart, for example with this dataset or this one:


I get the error message:

Requires at least 2 column(s) but only 1 provided.

If I add a different value to the bottom, however, I am able to create a pie chart as normal.

Is there a workaround for this? Or is this a known bug and/or lack of foresight in the design of the application?

  • Apparently the problem occurs because the values aren't numbers. Please add a demo spreadsheet shared with anyone with the link to view only. Apr 13, 2020 at 20:01
  • @Rubén I'm adding in a link, but I periodically clear out such junk files, so link depreciation will be an issue in the future. Unfortunately, the actual data I am working with does not involve number values (though maybe there's a way to code those in?).
    – Maroon
    Apr 13, 2020 at 21:22

1 Answer 1


If you want to change the default behavior of the Insert a Chart feature from Google Sheets, so please submit your feedback directly to Google by using Google Feedback

From Google Sheets web UI

  1. Click Help then Report a problem
  2. Complete the form and click Send

By the other hand, if you are open to do an extra step,

  1. Create your chart as usual
  2. On the Chart editor panel
    1. On the Chart type selector, select the 3D pie chart or another similar chart type
    2. Check the Aggregate checkbox

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.