#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Range Names by worksheet FlaAl Excel Discussion (Misc queries) 0 May 24th 06 05:14 PM
user input decides cell copy range beatrice25 Excel Discussion (Misc queries) 0 May 17th 06 06:51 PM
How can I run a spreasheet over range of input data ? prego Excel Discussion (Misc queries) 0 January 6th 06 08:09 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Variable Input Range for Combo Box Defoes Right Boot Excel Worksheet Functions 2 July 20th 05 03:44 PM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"