View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default 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