Creating tables with data that exceeds pivot table range

[pezman]

Hi I have a set of data laid out in the below format but with several 1000 rows of data. I need to plot a surface chart with X against Y with the focus on the measure coloumn but the dataset is too large for a pivot table. Could someone explainhow I can convert the format to (desired output) please.

Thank you very much in advance

(current - unordered)
X Y Measure
0 0 0.2
1 1 0.5
0 1 0.3
1 0 0.4

(desired output (escuse the --- but it wouldnt format otherwise ))

--X---0-----1
Y
0----0.2---0.4

1----0.3---0.5

 

[GlennUK]

What version of Excel? If you are using Excel 2003 or lower, then you will be limited to the number of columns that a table can cover, i.e. width ( max cols = 256 ).