Yes it's too simple for a matrix of ScatterCharts (see encl. picture).
The idea was to use a Function =CombineTwoArrays(Product1, Product2) that draws the data directly from the DataTable (row19).
To avoid to go via a ChartData table (row30) - where the number of combinations grows exponetially (messy).
'Sparklines for Excel' want a continous area (see function Fx row)... otherwise it would have been (too) easy.
//Ola
Bookmarks