scatter plot with two sets of x and y

[Susan Gallowau]

Hi,

I am simple data in four columns as shown below. I am trying to reproduce the figure that I could do it in excel in few steps. How can I do the same in spotfire

 

 

 

 

x1

y1

x2

y2

 

 

1

0

0.077013

101.5

 

 

0.73074

2.9

0.109689

80

 

 

0.387937

10.15

0.157539

70

 

 

0.280212

20.3

0.196687

60

 

 

0.168249

39.875

0.256259

40

 

 

0.12213

58

0.27

20

 

 

0.077013

101.5

0.332

0

 

 

 

 

0.368

-20

 

 

 

 

0.449

-40

 

 

 

 

0.499

-60

 

 

 

 

0.555

-80

 

 

 

 

0.611

-100

 

 

 

 

0.611

-120

[Khushboo Rabadia]

You cannot add x1,x2 on X-Axis in scatter plot. You can transform your data such that x and y values are in one column i.e. just importing x1,y1 data columns first in spotfire then adding rows to same data table this time choose x2, y2. In settings to add rows, match x1 with x2 and y1 with y2 so x2 and y2 values get inserted in x1 and y1 columns.

Then if you want, you can change the names of origin of data column to differentiate y1 and y2 values. Now you can easily plot data to scatter plot