Help on Chart!!!

[Jen]

Hi,

I have the following group of rates and would like to
chart them as somewhat like some National Grade
percentile test for student report.

Groups Rate LCL UCL 50% 90%
ABC Grp 78% 65% 91% 65% 76%
BAA, P.C. 56% 50% 62% 65% 76%
East 56% 50% 62% 65% 76%
West 65% 50% 80% 65% 76%
South 92% 80% 100% 65% 76%

Would like to chart them into the follow format with the
heading like the following:
Group Name LCL UCL 50% 90% Rates

It should be ranked basded on the rates. any suggestions.
Thanks,jen
..

 

[Jon Peltier]

Jen -

Delete "groups" from the top left cell. This tells Excel to use the
first column and first row for category labels and series names. Select
the range or a cell in the range, and make a line chart. I think you
want series in Columns (step 2 of the chart wizard). If you want the
results ranked, you can sort the data, before or after making the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______