Chart???

J

Jen

Hi,
I have a group of rates (%) for different groups, such as
34.9%, 40.5%, 51.% 60.9%, 65/3%, 73.0%, 78.9%, etc. I
wanted a chart to show the 25%, 50%, and 75% on the top
of the chart (like a header) and also arrange the rates
in a colomn and show the different points(rates)on the
chart. Is there anybody can show me some samples so that
I can learn from?
Thanks,
Jen
 
J

Jon Peltier

Jen -

Does this help? Arrange your data with the group name in the first
column, and the associated rate in the second. Put the label "Rate" (or
something else useful) in the cell above the rate column, but keep the
cell above the group names blank. Select the data, including the label
and blank cell, and start the chart wizard. This data could be plotted
on a Line chart, Bar chart, Column Chart. Experiment a little until la
certain chart type seems to show what you want.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top