Forum Discussion

shaynasosnowik's avatar
shaynasosnowik
Copper Contributor
Dec 31, 2020

Problem formatting bins

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

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 01, 2021

    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.

Resources