How to Create a Scatter Plot in Spotfire if all the X and Y data points are present in a single row.

[Sreeguru Devaki]

Hi Everyone,

I have the following scenario in Spotfire

All the X and Y data points to be plotted are in a single row, How can we plot the scatter plot with such data points

 

 

 

Column1

Column2

Column3

Column4

Column5

Column6

Column7

Column8

Column9

Column10

Column11

 

 

Unique ID1

X1

X2

X3

X4

X5

Y1

Y2

Y3

Y4

Y5

 

 

 

Column2 to Column 6 Contain X values,

Where as Column7 to Column 11 contain Y values.

Please let me know, ifthere any way to plot a scatter plot with these data points,

We would have multiple Unique ID's which would would have various values for Column2 to Column11

 

Thanks and Regards,

Sreeguru

[Kirsten Smith (she/her)]

You'll want to unpivot your data so that the x & y values are in single columns.

 

X1 Y1

X2 Y2

X3 Y3

X4 Y4

X5 Y5

etc