 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / September 2007Sorting 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? try using a dynamic range John Peltier http://peltiertech.com/ http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209 Charting FAQs List of articles by Peltier http://pubs.logicalexpressions.com/Pub  Signatureregards, Tom Ogilvy > 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? 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 SignatureCharles Chickering "A good example is twice the value of good advice." > 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.