Chart???

  • Thread starter Thread starter Jen
  • Start date Start date
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
 
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/
_______
 
Back
Top