ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Input range (https://www.excelbanter.com/charts-charting-excel/103245-input-range.html)

Irishrose28

Input range
 
I am trying to create a histogram When I click on create a histogram, a
screen comes up to add input range and bin range. I am not sure how to add
this information. I have tried may different things but it keeps telling me
I am not doing the right thing.

Jon Peltier

Input range
 
The input range is your list of values. The bin range is the numbers
representing the bins you want applied to the histogram. The bin values are
the top of each bin range, so if you want 0-1, 1-2, 2-3, etc, your bin range
should include 1, 2, 3, etc. Also, specify one additional bin, for any
values the largest bin value you supply.

You can have Excel make its own bins, as well. You might try this just to
see how the Histogram tool works.

Here's a web page with some histogram examples. I generally bypass the
Histogram tool in favor of making my own calculations and charts.

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Irishrose28" wrote in message
...
I am trying to create a histogram When I click on create a histogram, a
screen comes up to add input range and bin range. I am not sure how to
add
this information. I have tried may different things but it keeps telling
me
I am not doing the right thing.





All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com