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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

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,095,719
Messages
5,446,125
Members
405,383
Latest member
mccordscvs

This Week's Hot Topics

Top