Reverse Enginnering - Chart - Data Set
 

Need to emulate a semi-complicated Excel chart.

any way when looking at the existing chart to reverse look up its
source of data?

Reverse Enginnering - Chart - Data Set
 

Chart menu: Source Data/ Series
--
David Biddulph

"LiCal" wrote in message
...
Need to emulate a semi-complicated Excel chart.

any way when looking at the existing chart to reverse look up its
source of data?

Reverse Enginnering - Chart - Data Set
 

Get GrabIt add-in for $ on the website http://www.datatrendsoftware.com/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"LiCal" wrote in message
...
Need to emulate a semi-complicated Excel chart.

any way when looking at the existing chart to reverse look up its
source of data?

Reverse Enginnering - Chart - Data Set
 

You can select a series, and see in the SERIES formula where the data for
the series came from.

You can also extract chart data into new worksheet ranges using this
approach:
http://support.microsoft.com/kb/300643

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


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Chart menu: Source Data/ Series
--
David Biddulph

"LiCal" wrote in message
...
Need to emulate a semi-complicated Excel chart.

any way when looking at the existing chart to reverse look up its
source of data?