Excel "Sparklines" (Excel 2010)

Jun 2, 2009
Reaction score

It is known that the "Sparklines" source data should be in a contiguous range of cells.

I have that data in two non-contiguous ranges: A1:C1 and F1:K1- therefor in order to avoid copying and re-arranging the in helper cells - I assume filling a contiguous VBA Array with those non-contiguous ranges -> Name this Array and apply that name as the "Sparklines" source could be a good idea - but I couldn't figure out how to implement that Array to be the source for a "Sparklines" to be displayed in cell L1.
(It sounds to me as if the best way will be to run the above mentioned procedure via VBA Code).

Any help will be appreciated.


Last edited:


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel 2010 1
Excel Excel 2010 2
Excel MSO 2010 - Excel 3
Excel EXCEL 2010 HELP 1
Excel 2010 vs. Excel 2016 3
Excel Old Excel toolbar in Excel 2010 0
Excel Excel 2010 Full View 2
Excel Excel 2010 Corrupt Files 3