Lower range on histogram excel 2016 for mac

broken image
broken image

The table below summarizes fifty random values between 4.95 and 6.45.

broken image

In this tutorial I will go one further and show how to plot your histogram on a value-type horizontal axis. In Histogram on a Value X Axis Scale I showed a column-XY combination chart that simulates a horizontal value axis with markers that resemble tick marks and data labels. In Histogram with Actual Bin Labels Between Bars I showed a column-line combination chart that centered bin edge values between the bars of a histogram. The default category labels in Excel column charts produce histograms that don’t look very good.