Forum Discussion

Megan Ray's avatar
Megan Ray
Copper Contributor
Feb 06, 2017

Histogram

Hello!

 

I am having great difficulty in figuring out what i am doing wrong. I have to create a Histograms based on the last 60 days of high temperatures for my Stats class. While i understand how to generate the Histogram... it does not generate correctly? Instead of data across the graph, i am getting One Bar on One value... and the Date in the Table to the left of the graph does not reflect the data i'm actually using.

 

 

 

 

 

    • mars khur's avatar
      mars khur
      Copper Contributor

      Hello!

       

      I have a similar histogram issue.

       

      It gives me these wide-bars with irrelevant info.

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        Hi,

         

        With this initial chart

        select X-axis formatting and change default Automatic on By Category

        result will be like this

         

  • Joshua Adesoji's avatar
    Joshua Adesoji
    Copper Contributor
    Kindly send the sample file if you don't mind and state the Excel version you are using as well.
    • mars khur's avatar
      mars khur
      Copper Contributor

      Hello!

       

      I have a similar histogram problem! Mine turns out to be a bit different tho. Here's the screenshot: 

       It gives me these wide-bars with irrelevant info.

       

       

  • mars khur's avatar
    mars khur
    Copper Contributor

    Similar Problem! Mine turns out to be a bit different tho. Here's the screenshot: 

Resources