excel & charts (retrieving all chart-values automatically)
 

I have the following problem:

We have to create excel charts automatically, based on some "templates" made
by the user, who has the possibility to define how some charts should look
like.
I want to open the template automatically, read all properties of the
existing chart-objects and recreate them based on some new data fetched from
a webservice; especially based on one chart I have to create let's say 100
similar charts with other data.

But I cannot manage to read all properties of an excel-chart automatically
without fetching each property explicitely. If I could do so, I could save
all the chart's properties in an XML-file and assign these properties again
when creating the new charts == I even cannot manage to assign all
properties automatically, how is this done??

Thanks in advance

Greetings

Stefan

excel & charts (retrieving all chart-values automatically)
 

Stefan -

You could copy the chart and paste it elsewhere, then update the data
source of the pasted chart. Longer term, you could save the chart as a
user-defined custom type, and apply it when creating a new chart based
on different data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Stefan Walther wrote:
I have the following problem:

We have to create excel charts automatically, based on some "templates" made
by the user, who has the possibility to define how some charts should look
like.
I want to open the template automatically, read all properties of the
existing chart-objects and recreate them based on some new data fetched from
a webservice; especially based on one chart I have to create let's say 100
similar charts with other data.

But I cannot manage to read all properties of an excel-chart automatically
without fetching each property explicitely. If I could do so, I could save
all the chart's properties in an XML-file and assign these properties again
when creating the new charts == I even cannot manage to assign all
properties automatically, how is this done??

Thanks in advance

Greetings

Stefan