| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return chart's source data location/range
Hi,
I am trying to figure out if anyone knows how to have excel (vba) code to return the source location of where the chart is getting its data from. Ex: if i were to select a chart it will highlight the cells where it is getting its data from to plot. what is the command (code) to have it return the range ( : ) into a variable in vba ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
return chart's source data location/range
Not an easy one, see what John Walkenbach has to say... http://j-walk.com/ss/excel/tips/tip83.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "HD" wrote in message Hi, I am trying to figure out if anyone knows how to have excel (vba) code to return the source location of where the chart is getting its data from. Ex: if i were to select a chart it will highlight the cells where it is getting its data from to plot. what is the command (code) to have it return the range ( : ) into a variable in vba ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return the location (as a range) of ActiveCell? | Excel Discussion (Misc queries) | |||
| Can you make a chart's data *always* refer to a dynamic range name? | Charts and Charting in Excel | |||
| Programmatically determine Chart's data source | Excel Programming | |||
| How to identify source or location of MAX_VALUE in range | Excel Worksheet Functions | |||
| How do I return the values of a chart's data range? | Excel Programming | |||
![HD[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
