Sparklines Visible property

User avatar
ErikJan
BronzeLounger
Posts: 1258
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Sparklines Visible property

Post by ErikJan »

I have several sparklines in my sheet and want to have an option to 'hide' them. I'm already looping through all of these (updating ranges etc.), can't find a 'visible' property.
So the alternative is to make the plot range one point or other creative approaches then?

User avatar
HansV
Administrator
Posts: 78642
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sparklines Visible property

Post by HansV »

You could set the color to white (or rather, to the background color of the cells), e.g.

Range("C1:C10").SparklineGroups(1).SeriesColor.Color = vbWhite
Best wishes,
Hans