Sorting rows with sparklines

Nyanko

Active Member
Joined
Sep 1, 2005
Messages
437
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
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Nyanko

Active Member
Joined
Sep 1, 2005
Messages
437
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,829
Messages
5,598,347
Members
414,232
Latest member
MIA10_KO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top