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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies