Prev Previous Post   Next Post Next
  #1   Report Post  
durino13
 
Posts: n/a
Default Histogram


I have a array of values, for instance: 1 2 3 4 5 6 atc. As soon as I
want to create a histogram, everything is working well, till I
explicitly write down the bin values ...

But when I do not tell to excel the bin range, excell tryies to find
this range automatically. The problem is, that excel did not find the
values from the array, like 1 2 3 4 5 6, but instead of them, he
resolves something like 1 | 2,33333 | 3,66666 atc ...

I have also changed the format of the array to numbers with a one
decimal place, but it did not solve my problem

Any idea?


--
durino13
------------------------------------------------------------------------
durino13's Profile: http://www.excelforum.com/member.php...o&userid=26334
View this thread: http://www.excelforum.com/showthread...hreadid=396043

 
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
histogram canadian excel user Excel Discussion (Misc queries) 1 July 30th 05 11:50 PM
How to get rid of "More" on a Histogram Chart? Sam Charts and Charting in Excel 0 June 6th 05 04:34 PM
Histogram john liem New Users to Excel 0 May 11th 05 01:02 PM
How do I create a Histogram for relative frequency distributions? pipereed Excel Discussion (Misc queries) 1 February 28th 05 03:40 AM
Charting cumulative values in histogram ? TonyB Charts and Charting in Excel 3 February 22nd 05 04:23 PM


All times are GMT +1. The time now is 08:52 PM.

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"