excel & charts (retrieving all chart-values automatically)

  • Thread starter Thread starter Stefan Walther
  • Start date Start date
S

Stefan Walther

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
 
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
 
Back
Top