ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA? (https://www.excelbanter.com/excel-worksheet-functions/93243-how-can-i-create-histogram-graph-my-data.html)

NNAMDI

HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
 
I NEED HELP ON HOW TO CREATE A HISTOGRAM GRAPH FOR MY DATA?

Mike Middleton

HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA?
 
NNAMDI -

I NEED HELP ON HOW TO CREATE A HISTOGRAM GRAPH FOR MY DATA? <


(1) Use COUNTIF or FREQUENCY worksheet functions (or pivot table) to create
the frequency distribution, and then use the Chart Wizard to create a Column
chart.

(2) Use the Histogram tool of Excel's Analysis ToolPak.

(3) Download the free Better Histogram add-in from www.treeplan.com.

(4) Search Google Groups for even more alternatives.

- Mike
www.mikemiddleton.com




All times are GMT +1. The time now is 04:46 PM.

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