My input "ID" "Label" "*Stype*" "Ntype" "Stype_No" "*log*" "S1" "xxx" "A/A" 1 6 2.8 "S1" "xxx" "A/G" 2 2 3 "S1" "xxx" "G/G" 3 1 4 "S2" "yyy" "A/A" 1 1 6.8 "S2" "yyy" "A/G" 2 2 7 "S2" "yyy" "G/G" 3 6 7.4 "S2" "yyy" "NULL" "null" "null" 8 "S3" "zzz" "A/A" 1 3 12 "S3" "zzz" "A/G" 2 3 14 "S3" "zzz" "G/G" 3 3 16 "S3" "zzz" "NULL" "null" "null" 18 "S3" "zzz" "NULL" "null" "null" 20 I would like to draw a single scatter plot for every ID (S1 -plot and S2-Plot....)by using *Stype* as X axis and *log* as Y-axis with a header "D_Scatterplot". For example S1-Plot looks like this X-axis consider Stype A/A=1 A/G=2 G/G=3 and their Stype_No (6,2,1)means A/A i.e, 1 repeated 6 times with log values 2.8,3 and 4 and A/G i.e. 2 repeated 2 times and G/G i.e. 3 1 time with the same log values. simply it looks like this 1 2 3 2.8 1 2 3 1 4 1 1 1 Y-axis Label_ 6 | log 5 | 4 | *** 3 | ** * * 2 | ** * * * 1 | 0 |______________________ A/A A/G G/G ID* Thanx n advance Pearl