Dec 31 2020 07:15 AM
Hi,
I've been trying to make histograms on Excel 16.3 on my mac - every tutorial I see for updating bins suggest the format axis option to adjust bins but my format axis does not have the same options. I can't figure out how to adjust the bins on my histograms. Can anyone can tell me where I'm going wrong?
Thanks
Jan 01 2021 01:38 AM
@shaynasosnowik Right-click (or two-finger-click on the track pad) on a data series in the histogram. Select "Format Data Series".
Here you can change the bin settings.