Forum Discussion
Number of bins
How do I change the number of bins on a Mac computer in excel?
On a Mac myself. Select the axis, then "Format axis". A dialogue box should appear as indicated in the picture below. From there, you can change the settings.
How did you get the axis options box? I only have Options, Tick marks, and Number
Must admit that I'm no charting expert but found where "bins" are in Excel for Mac when creating a histogram. Perhaps the attached picture helps. The bins came up under "Format Data Series".
- I found how to get to it, I just needed to double click on the bars and not the axis’s