ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a histogram (https://www.excelbanter.com/charts-charting-excel/121124-how-do-i-create-histogram.html)

tish817

How do I create a histogram
 
I need to create a histogram and can not figure out how to group my data, or
where I can find 'histogram' in the chart dialogue box. I'm totally lost!!

Bernard Liengme

How do I create a histogram
 
A) Use Tools | Data Analysis (if you installed it) and locate Histogram
OR
B) Learn how to use the FREQUENCY function and make an XY chart of the
result
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"tish817" wrote in message
...
I need to create a histogram and can not figure out how to group my data,
or
where I can find 'histogram' in the chart dialogue box. I'm totally
lost!!





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

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