Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do I get a histogram using EXCEL

Using Office 2007 how to you draw a histogram, given grouped data and
frequency?
I know you could do this with 2003 using the tools option.
Thanks

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default How do I get a histogram using EXCEL

ngwenya -

If the data are already grouped, create a Column chart type.

The Histogram tool is used when you have ungrouped, raw data. It prepares a
frequency distribution, i.e., it groups the data, and then it creates a
Column chart.

If you have the original, ungrouped, raw data, you can use the Histogram
tool, or you could use my free Better Histogram add-in, available at
www.treeplan.com.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"ngwenya" wrote in message
...
Using Office 2007 how to you draw a histogram, given grouped data and
frequency?
I know you could do this with 2003 using the tools option.
Thanks



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
Excel Histogram couthbaron Excel Discussion (Misc queries) 1 August 19th 07 08:33 PM
Histogram in Excel jtomdd Charts and Charting in Excel 2 February 5th 07 05:54 AM
How do I make a histogram in MS Excel? Marilyn Sowers Charts and Charting in Excel 1 September 17th 06 05:30 AM
I was creating a histogram; now i have data but no histogram. ShannonMills3 Excel Worksheet Functions 0 June 14th 06 12:03 AM
How to Histogram w/o raw data but histogram Table on Excel 2005 Charts and Charting in Excel 1 February 1st 06 06:48 AM


All times are GMT +1. The time now is 01:54 PM.

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

About Us

"It's about Microsoft Excel"