Essentially you have to find all of the properties for all of the elements
in the chart. It's not really hard, but it's intricate and tedious work. I
am in the process of quoting on such a utility, which may eventually become
a commercial product.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Matt Williamson" wrote in message
...
I'm looking for a way to get all of the paramters used for creating a
chart so I can do it dynamically. Someone else created a fairly
complicated chart and I'd like to be able to re-create it in code so I can
change the data range and title but I'm not sure how. It's complicated
enough that I haven't been able to re-create it manually yet (so I can
just record it and get the params that way) I've been reading all of the
dynamic chart code in the MS KB and various websites, but I haven't found
any code to document an existing chart to create it dynamically.
TIA
Matt