|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 1st, 2006, 04:27 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
How to Histogram w/o raw data but histogram Table on Excel
Hi
If I have raw data, then I understand the method of doing Histogram with Excel. What is if the Histogram is already presented in a Table and I have to plot the diagram in Excel? eg. (Note "-" means less then the upper value) Range Freq 0-10 2 10-20 12 20-30 15 30-40 10 40-50 1 Can Excel take the above data and plot an Histogram? Is there anything other than Excel? 
|
|
#2
February 1st, 2006, 06:48 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to Histogram w/o raw data but histogram Table on Excel
2005 -
Can Excel take the above data and plot an Histogram? Yes. Use the Chart Wizard to create a Column chart type. Select the chart, and choose Chart | Source Data | Series. Your "Freq" data are chart Values, and your "ranges" are chart Category (X) axis labels. Is there anything other than Excel? In my life, yes. - Mike www.mikemiddleton.com "2005" wrote in message oups.com... Hi If I have raw data, then I understand the method of doing Histogram with Excel. What is if the Histogram is already presented in a Table and I have to plot the diagram in Excel? eg. (Note "-" means less then the upper value) Range Freq 0-10 2 10-20 12 20-30 15 30-40 10 40-50 1 Can Excel take the above data and plot an Histogram? Is there anything other than Excel?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
| PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
| Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Linear Mode
