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

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

In article <368c01c42954$9f689740$(E-Mail Removed)>,
(E-Mail Removed) says...
> 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
>