Hi,

1. Easiest way is just to put the two sets of data below each other.

2. Second way is to modify the series formula:

=SERIES(Sheet3!$D$3,(Sheet3!$C$4:$C$6,Sheet3!$F$4: $F$6),(Sheet3!$D$4:$D$6,Sheet3!$G$4:$G$6),1)

In this case I started with
=SERIES(Sheet3!$D$3,Sheet3!$C$4:$C$6,Sheet3!$D$4:$ D$6,1)
and just add the second x range and the second Y range to the formula.

It might make most sense to use a scatter chart if you are doing this with
both axes containing numbers.

--
Thanks,
Shane Devenshire


"Cordell Cahill" wrote:

Id like to put data from different columns in a chart. I've got a spreadsheet
with multiple 2x20 'tables'. In the first column is speed and in the second
column is a torque value for the given speed in the first column. Problem
seems to be that the 1st column in each of these 'tables' arent the same
values, but there all speed. say I have in the first table speed values of
10,15,20,25.... and in another table I have speed values of
12,16,22,23....... Id like to plot all of the table on 1 graph(line). Anyway
to do this within excel(vista)?