Home

Change Histogram bin values in Excel for iPad

Schef53
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!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies