Excel "Sparklines" (Excel 2010)


Joined
Jun 2, 2009
Messages
3
Reaction score
0
Hi,


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.

Elm






 
Last edited:
Ad

Advertisements


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

Top