View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
matelot matelot is offline
external usenet poster
 
Posts: 72
Default Read series values range of a chart

Is it possible to read the existing range defined in the values under source
data/series/Values? The reason is that I have a checkbox to hide/show the
value. Since I don't know the range, I want to read and put into a temp
variable so that when the user wants to show it again, I can add my temp
variable into the values box.
Is it doable?

Thanks