View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefan Walther Stefan Walther is offline
external usenet poster
 
Posts: 1
Default 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