Change Histogram bin values in Excel for iPad

Highlighted
Occasional Visitor

I entered 450 data points into a file in Excel for iPad. I would like to show the frequency with which the various data occur. I used the tool to insert a histogram into the worksheet  y selecting Insert > Chart > Histogram. The resulting chart isn’t meaningful to the reader because the values are in days, but the bins that Excel picked seem to be random values, whereas I would like to group them into weeks, i.e., 1 - 7 days, 8 - 14 days, etc. I can’t seem to find a way to adjust the values of the histogram bins to values ones other than those that were automatically created when I inserted the histogram. Can someone please tell me if there is a way to adjust these values or am I stuck with what was automatically generated? Many thanks!

 

0 Replies