If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart with a lot of columns
If have an excell sheet with 24 sets of XY data (48 columns). I was
wondering if anyone had a time saving tip for putting all this data on a scatter chart. Here are how my columns are organized: Time, Position1, Time, Velocity1, Blank, Blank, Time, Position2,Time,Velocity2, Blank, Blank.... I think that I am facing two seperate challanges: 1) How do I get excell to automatically put time on the x-axis and Position and Velocity on the y? 2) How do I get excell to automatically put the position1, position2, and so on into different data series. If their is no way around the tedious process of manually selecting data series just let me know. I am just hoping that there is a better way. |
Thread Tools | |
Display Modes | |
|
|