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
|
|||
|
|||
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
|
|||
|
|||
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 |