Sparklines - Creating Summary and want to source sparkline data from another table

Hi -
I am creating a summary table that has "top ten accounts" and I'd like to include a sparkline. I have a pivot table in another worksheet that has the data for 1000 accounts and it's formatted for use in the sparkline.
When I do this manually for one-off situations, this works fine, but I'd like to expand this and it'd be a hassle to do manually.

Question is:
- How can I embed a vlookup in my sparkline data formula so that it knows which row to get from the data table - I can't seem to get formulas to be accepted in the sparkline data entry field.


One thing I tried that didn't work - created sparklines on the pivot data tab for all accounts, and then vlookup on my top10 to bring back the sparkline... however, this returned a value of 0.
Any help is appreciated.

Thanks

Please attach a sample of your workbook. This will make is much easier to find a solution without having to re-create your data. Remember to remove/replace sensitive data before uploading the file.

Hi,

Although it is true that you cannot use formulas for the sparkline data, you can use a defined name and that defined name can use a formula as long as it returns a range.

The required steps would be:

• select cell E8 on the Summary sheet
• define a new name called SparkData using the following formula: =INDEX(PIVOT!$B:$F,MATCH(SUMMARY!$B8,PIVOT!$A:$A,0),0)
• create a sparkline for cell E8 using =SparkData as the source data.
• Copy E8 down your list. (You cannot unfortunately apply the sparklines to multiple cells directly)

You're welcome. Thank you for the reputation.