Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphing | New Users to Excel | |||
Graphing n^1.85 | Charts and Charting in Excel | |||
Graphing | Excel Discussion (Misc queries) | |||
HELP with Graphing. | Charts and Charting in Excel | |||
graphing | Excel Discussion (Misc queries) |