ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrong Frequency for Histograms (https://www.excelbanter.com/excel-discussion-misc-queries/175830-wrong-frequency-histograms.html)

jmease

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?

Jon Peltier

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?




jmease

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?






All times are GMT +1. The time now is 03:23 PM.

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