Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
how do i read off values from a chart created in excel? | Excel Discussion (Misc queries) | |||
How do I read values from a line chart? | Charts and Charting in Excel | |||
How do I use a Defined Name range for a value series in a chart? | Charts and Charting in Excel | |||
Chart -- How to chart 65536 values in 1 series? | About this forum |