bryanblack
New member
- Joined
- Jul 17, 2009
- Messages
- 1
- Programming Experience
- 3-5
Hey guys,
I need to find a way to gain access to the range an Excel Chart has currently.
I have been exploring the ChartObject and Chart objects but can not find any way to know what the current source data range is for the Chart I am looking at.
The Excel libraries for .NET has the method setSourceData which lets you set the data the chart uses but I can not find the properties or method(s) that allows you to get a range object or possibly an integer telling you the x and y coordinates of the range that was selected for the chart. If anyone could point me in the right direction with this that would be great !
I need to find a way to gain access to the range an Excel Chart has currently.
I have been exploring the ChartObject and Chart objects but can not find any way to know what the current source data range is for the Chart I am looking at.
The Excel libraries for .NET has the method setSourceData which lets you set the data the chart uses but I can not find the properties or method(s) that allows you to get a range object or possibly an integer telling you the x and y coordinates of the range that was selected for the chart. If anyone could point me in the right direction with this that would be great !