Problem formatting bins

Copper Contributor

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

1 Reply

@shaynasosnowik Right-click (or two-finger-click on the track pad) on a data series in the histogram. Select "Format Data Series".

Screenshot 2021-01-01 at 10.34.44.png

 

Here you can change the bin settings.

Screenshot 2021-01-01 at 10.35.20.png