Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Wrong Frequency for Histograms

Whenever I create a histogram in Excel the frequencies generated are
incorrect and I have to manually count and update in order to reflect
accurate information. Any ideas on why this is happening or how to fix it?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Wrong Frequency for Histograms

I usually generate the numbers myself without using the ATP histogram.

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

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


"jmease" wrote in message
...
Whenever I create a histogram in Excel the frequencies generated are
incorrect and I have to manually count and update in order to reflect
accurate information. Any ideas on why this is happening or how to fix
it?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Wrong Frequency for Histograms

I considered doing it that way but I have so much data and so many histograms
to create that I really need for the data analysis function to work properly.
I appreciate your response.

"Jon Peltier" wrote:

I usually generate the numbers myself without using the ATP histogram.

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

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


"jmease" wrote in message
...
Whenever I create a histogram in Excel the frequencies generated are
incorrect and I have to manually count and update in order to reflect
accurate information. Any ideas on why this is happening or how to fix
it?




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
Histograms Green Jigsaw Excel Discussion (Misc queries) 1 November 6th 07 09:09 AM
Insert Calculated Field (wrong Qty*Price = wrong Amount) Edmund Excel Discussion (Misc queries) 8 October 4th 07 12:13 PM
histograms - frequency and relative frequency? confusedstudent Excel Discussion (Misc queries) 2 February 8th 06 08:20 AM
histograms just me Charts and Charting in Excel 1 February 1st 06 10:08 PM
Frequency for Histograms in Excel Jim Charts and Charting in Excel 7 February 24th 05 07:33 PM


All times are GMT +1. The time now is 01:50 AM.

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

About Us

"It's about Microsoft Excel"