Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
user input decides cell copy range | Excel Discussion (Misc queries) | |||
How can I run a spreasheet over range of input data ? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Variable Input Range for Combo Box | Excel Worksheet Functions |