| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
| Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
