Graphing data

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

Say I have a column of measurements - it might be the heights I have
measured of 300 people. The measurements are in no particular order.

Is there a procedure in Excel that will automatically group the data and
graph it? A sort of one-click approach?

Thanks

Geoff
 
If you have the Analysis Toolpak add-in installed,
a pretty close fit to what you're after might be to use
Tools > Data Analysis > Histogram

Try playing around along these lines

Assume your height data is in A1:A300

Prepare a bin range first in say B1:B4
with values (say) in:

B1: 75
B2: 125
B3: 175
B4: 225

Click Tools > Data Analysis > Histogram > OK

In the Histogram dialog box:

Input:

Input range: A1:A300
Bin range: B1:B4

Click to check Labels (if applicable)

Output options:

Click to check the following:

New Worksheet Ply
Pareto (sorted histogram)
Cumulative Percentage
Chart Output

Click OK

The outputs (Charts & tabulated info)
will appear in a new sheet to the left of the data-sheet

hth
Max
 
Thanks, Max. That is very helpful.

Geoff


Max said:
If you have the Analysis Toolpak add-in installed,
a pretty close fit to what you're after might be to use
Tools > Data Analysis > Histogram

Try playing around along these lines

Assume your height data is in A1:A300

Prepare a bin range first in say B1:B4
with values (say) in:

B1: 75
B2: 125
B3: 175
B4: 225

Click Tools > Data Analysis > Histogram > OK

In the Histogram dialog box:

Input:

Input range: A1:A300
Bin range: B1:B4

Click to check Labels (if applicable)

Output options:

Click to check the following:

New Worksheet Ply
Pareto (sorted histogram)
Cumulative Percentage
Chart Output

Click OK

The outputs (Charts & tabulated info)
will appear in a new sheet to the left of the data-sheet

hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<dot>yahoo<dot>com for email
Click to expand...
 
Back
Top