Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
histograms
I have a problem with entering the data to get the result that I need.A study
examined how long air conditioning units operated after repair(in hours), I have the operating times and know to put them in the 2nd column, but i don't know how to tell the program that ineed to have results in six fourty hour wide classes.I'm not sure of the 1st column as the times are for one unit. I'm using excel 2003 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
histograms
In article , "?B?
anVzdCBtZQ==?=" <just says... I have a problem with entering the data to get the result that I need.A study examined how long air conditioning units operated after repair(in hours), I have the operating times and know to put them in the 2nd column, but i don't know how to tell the program that ineed to have results in six fourty hour wide classes.I'm not sure of the 1st column as the times are for one unit. I'm using excel 2003 Put the upper bounds of the desired classes in 6 adjacent cells in a column. Now, create a Histogram with Tools | Data Analysis... | Histogram In the resulting dialog box, the Input Range is your data set (what you called the 2nd column) and the Bin Range is the new 6 cell range you just created. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
histograms | Excel Discussion (Misc queries) | |||
can bin range for histograms be on a different worksheet? | Excel Discussion (Misc queries) | |||
Frequency for Histograms in Excel | Charts and Charting in Excel | |||
Histograms: how change number of bins | Excel Discussion (Misc queries) | |||
In Excel 2003, the histograms are incorrect. Excel shows a bar gr. | Excel Discussion (Misc queries) |