Histogram chart shows wrong values on Y axis
- Observed: Bars are plotted as if their y-values where much smaller than they actually are
- Expected: Bar height represents the value correctly.
I created a histogram using the Statistics menu from a simple column of values. The resulting sheet shows the counts correctly in column C.
The chart was generated automatically with the sheet. Only changes I made for better clarity: I moved it, changed X axis format, Series color.
The y-Axis has automatic settings applied, but uses a range up to 5 instead of expected 27. A value of 1 is shown as a bit less than 0.2.