I have 4 columns on a spreadsheet- sample ID, x value, y value, and series (of which there are three). I sort the columns based on series so I can group the data to graph, but I have to resort based on sample ID (to put them back in order). When I do this, the graph data is linked to the cells rather than the data that I originally thought I linked it to. I don't really know how to solve this problem, so any help would be greatly appreciated! Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel chart stuff
- Thread starter grassaj
- Start date
RobBroekhuis
Technical User
I guess you could write a macro that creates three new ranges with formulas pointing at the raw data, then use the new ranges to create the graphs with. Should be pretty straightforward.
Rob
Rob
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question