determining and existing charts data source

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

determining and existing charts data source

Is it possible to determine the range a chart is using for its datasource?

I am updating a series of list objects in a xls with a varying number of
rows and want to determine if any charts are refering to my list objects and
if they are, set the datasources to the new range.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bar width on existing chart changes when changing source data	Robert Brown	Charts and Charting in Excel	5	April 30th 10 07:18 PM
VBA to automatically change source data for existing chart	ETLahrs	Charts and Charting in Excel	3	April 21st 08 09:27 PM
VBA to automatically change source data for existing chart	ETLahrs	Charts and Charting in Excel	0	April 21st 08 08:41 PM
Add source data to an existing chart?	navychef	Charts and Charting in Excel	2	December 22nd 05 11:22 PM
Adding more source data to existing scatter plot	Tom	Charts and Charting in Excel	1	March 21st 05 10:03 PM

All times are GMT +1. The time now is 07:19 PM.

Menu

About Us