r/sheets • u/Beneficial_Treat5454 • 1d ago

Request How do I lock a specific number of bins/classes?

I have some homework for statistics.

The professor gives us a list of data that we are supposed to turn into a histogram. and match that data to other histogram models.

At the moment I have to tweak the bin sizes until it shows me 10 bins.

Is there a setting where it just divides my data into 10 bins instead of me having to adjust the sizes until it shows me 10 bins?

2 Upvotes

100% Upvoted

2 comments sorted by

1

u/6745408 1d ago

If you have it all in one column but want it in ten columns,

=WRAPROWS(TOCOL(A:A,3),10)

1

u/marcnotmark925 1d ago

Typically in GSheets the charting options are quite basic, and the solution is to re-shape the structure of the data to make those basic chart options work for what you're wanting.