Histograms - StdDev help

thegreencar

New Member
Joined
Feb 8, 2016
Messages
34
Hi,
I am hoping you can help. I am trying to display my information as a histogram using Std Dev.
I can get the curve correct but I am having trouble with the labeling of the axis.
The X axis is showing values which I did not want.

What I want is to show each bin on the X axis and the frequency on the right.

Can someone help explain what the values showing on the X axis relate to and how to change this to the bins stated?
Attached link to the sheet.
https://pgicloud-my.sharepoint.com/...IY5LSsjrY&expiration=2017-05-10T08:18:03.000Z
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

thisoldman

Well-known Member
Joined
Jan 5, 2014
Messages
1,073
Try redrawing the chart without including the the row labeled "More" in the frequency table.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,362
Messages
5,486,394
Members
407,544
Latest member
mguevara

This Week's Hot Topics

Top