I have read the documentation on how to set a chart source range on a freshly created chart in excel using the .Nseries method. However I am clueless on how to obtain and modify this data source range from an existing worksheet where the chart position is unknown. This is often the case when importing a chart and dataset from powerpoint as an OLE Excel object
Thanks for the fast reply. I am still having problems, i've enclosed the code segment below and attached the powerpoint template. If you could spare the time to see where I am going wrong it would really be appreciated.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.