Histogram

[Megan Ray]

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.

[#2]

Hi Megan, can you attach an example file, or if not then some screen shots?

[#3]

Kindly send the sample file if you don't mind and state the Excel version you are using as well.

[#4]

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

[#5]

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.

[#6]

Hello!

I have a similar histogram issue.

It gives me these wide-bars with irrelevant info.

[#7]

Hi,

With this initial chart

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

result will be like this

[#8]

Thanks a lot!
Problem Solved! :)

[#9]

Hi. I have the same problem, but are using an Ipad. How can this be done in excel on Ipads?

[#10]

Sorry, have no idea - I have no iPad in my environment