snb & wher, sorry but your suggestions are roughly what I already have (see the Book1.xlsm attachement).

The 'Sparkline for Excel' function =scatterchart(xyarea,,,) function want one continous area.
I need a single cell formula that can pass the whole xyarea (array) as one continouse area in one single cell. i.e. join row C20:G20 & C23:G23
I think I can only be done by a UDF, but do surprice me.
//Ola