• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sparklines Using Non-Contiguous Range

J

jdppep

Member
Is it possible to create a sparkline using a non-contiguous range? All data is located within the same row; however, evenly spaced, two cells apart. Would a named range work and if so, how would I name a range the sparkline would recognize?

My data is located: =Dashboard!E15,G15,I15,K15,M15,O15,Q15,S15

I am trying to avoid dummy rows/columns.

Thank you!
 
Give the non-continuous cells a Range name, such as "MyRange", and you can then have the sparkline refer to that named range. :)
 
Specifically, how should I enter the range information?

If I simply select the individual cells:

=Dashboard!$E$15,Dashboard!$G$15,Dashboard!$I$15,Dashboard!$K$15,Dashboard!$M$15,Dashboard!$O$15,Dashboard!$Q$15,Dashboard!$S$15

and name them as a range "Sparkline"

I receive the following error when I go to Create Sparklines and enter the Data Range: Sparkline
"The reference for the location or data range is not valid"

Of note, there are empty cells in this range.
 
Put an "=" sign in front of the range. In the dialogue, it would be:
=Sparkline
On the Sparkline design ribbon, Edit Data, you can choose how the sparkline handles empty cells.
 
I was placing the sparkline in a merged cell, which did not work. After defining the sparkline, I was able to merge the cells.

Thanks!
 
You must log in or register to reply here.
Back
Top