Sorting rows with sparklines

[Nyanko]

Hi,

I have a list of sites with various different metrics and I am compiling a dashboard/summary sheet to make sense of all of the data. I have one line and win/loss sparkline for each site with the source data for each sparkline held in a different sheet.

Example data :
The source data is held in Sheet1 and the dashboard is held in Sheet2

Sheet1
Site........Jan...Feb...Mar...etc
Site One...100...100...500
Site Two...500...500...100

Sheet2
Site One...Spark1 (Source : Sheet1!A2:C2)
Site Two...Spark2 (Source : Sheet1!A3:C3)

However when I sort the dashboard the sparklines don't change :

Sheet2
Site Two...Spark1 (Source : Sheet1!A2:C2)
Site One...Spark2 (Source : Sheet1!A3:C3)

I will have many different datasheets feeding into the dashboard and the potential for 100s of sites. I will be creating macros to sort the rows according to different scenarios. Short of duplicating the data for each spark within the dashboard is there a way to sort the sites and have the sparks update ?

Many thanks for any advice

 

[Nyanko]

Just as an additional note, I have just tried my planB of duplicating the source data next to sparkline, which works for sorting purposes. However, when I hide the data columns (as I only want the graphical representation of the data) the spark line disappears

Ahhh I've just found the Hidden & Empty cells option so my planB works, but it's not efficient to duplicate my data like this so a better solution is still required