What kind of graphs do you want? Could you use a line chart? The values
could be in the same chart, self-sorted because the line with greater values
appears higher in the chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Min" wrote in message
...
Hi there,
I've got a lot of data that im looking at & was hoping to produce some
graphs so that I can easily analyse them. The only thing is that each
record
has between 8 &15 values. I want to create a graph for each of these
categories but have the graphs in order from highest to lowest. Is there a
way of doing this without copying the data & sorting it each time or would
it
be best to use some other software....?
Thanks very much
Min :o)