Sorting and graphing
 

I have 200 rows of data and it is inputed daily with the latest data showing
up on the last row. If I wanted to sort this data by contract and still get
a good graph how would this be done?

Sorting and graphing
 

try using a dynamic range

John Peltier
http://peltiertech.com/

http://pubs.logicalexpressions.com/P...cle.asp?ID=209
Charting FAQs

List of articles by Peltier
http://pubs.logicalexpressions.com/Pub

--
regards,
Tom Ogilvy


"Eric" wrote:

I have 200 rows of data and it is inputed daily with the latest data showing
up on the last row. If I wanted to sort this data by contract and still get
a good graph how would this be done?

Sorting and graphing
 

Have you looked into Pivot Tables and Charts? They work very well for being
able to resort data on the fly. If you would like you can send me an example
file and I'll add some pivot tables for you so you can see how they work. My
email is chick65stang AT yahoo DOT com
--
Charles Chickering

"A good example is twice the value of good advice."


"Eric" wrote:

I have 200 rows of data and it is inputed daily with the latest data showing
up on the last row. If I wanted to sort this data by contract and still get
a good graph how would this be done?