Viewing chart code

[Hammer_757]

Is there a way to look at all the structure or code for a chart at once
when I say code what I mean is like in the source data menu you ca
select a series and the formulas for "Name" "Values" etc. is displaye
for editing. an example is " VALUE = 'Xbar R PHASE MOD2'!$D$44:$L$44"

Is there a way to display all the information for all the sources in
table or ... ? It would make troubleshooting complex tables and massiv
alterations much easier.


Thank

 

[Jon Peltier]

Hammer -

I don't know of a way that Excel does this without writing a program.

You could write some code in VBA which could tabulate these items for
you. In so doing, you'd learn about VBA, and about the object models for
Excel and its charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Hammer_757]

I was afraid of that

I would be a good project however. Ive pieced together some VBA fo
charts and data conversion this looks like the next step in tha
learning process