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

Read series values range of a chart
 

You can parse the series formula. John Walkenbach has a class module which
does this for you:

http://www.j-walk.com/ss/excel/tips/tip83.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"matelot" wrote in message
...
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

Read series values range of a chart
 

Jon,
That's exactly what I need. Thanks so much for pointing me to the right
direction.

Mat

"Jon Peltier" wrote:

You can parse the series formula. John Walkenbach has a class module which
does this for you:

http://www.j-walk.com/ss/excel/tips/tip83.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"matelot" wrote in message
...
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