Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

histogram - get the axis correctly labelled

The new histogram feature is great and long overdue. It is a shame that it is necessary to then manually edit the axis label in paint. A histogram is a plot of continuous data it should not have category labels but a continuous scale. See for example:
http://www.bbc.co.uk/schools/gcsebitesize/maths/statistics/representingdata3hirev3.shtml
(For you US bods GCSE is the 16+ standard exams taken in the UK)
Also:
http://www.uvm.edu/~rsingle/other/JMP-intro/default8.html

https://www.tutorialspoint.com/sas/sas_histograms.htm

You will notice that in all of these articles the histogramhas a continuous scale. If we put a smoothing spline over it - it must have a continous scale.
https://stackoverflow.com/questions/1497539/fitting-a-density-curve-to-a-histogram-in-r

I lecture at a University and the x-axis with the category labels is incorrect.

9 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base