chart the rates

[jen]

Hi,

I have the following group of rates and would like to
chart them.

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

 

[Tushar Mehta]

Not quite sure what you need help with. Ensure that the top 50% and
90% are text (put a single apostrophe before each of them). Click
anywhere in the table, then the Chart Wizard. Pick the chart of
interest. In the next dialog box, adjust the row/column orientation as
desired. Once complete, and if the chart supports the capability,
double-click any of the series, then select the Options tab.
Experiment with high-low lines and up/down bars.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions