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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

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,098,998
Messages
5,465,895
Members
406,453
Latest member
CeReaLK

This Week's Hot Topics

Top