Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie Chart - Columns | Charts and Charting in Excel | |||
Add Chart Columns | Charts and Charting in Excel | |||
Bar chart with no zero columns | Charts and Charting in Excel | |||
Chart columns | Charts and Charting in Excel | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel |