Reverse Enginnering - Chart -> Data Set

[LiCal]

Need to emulate a semi-complicated Excel chart.

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

 

[David Biddulph]

Chart menu: Source Data/ Series

 

[Bernard Liengme]

Get GrabIt add-in for $ on the website http://www.datatrendsoftware.com/
best wishes

 

[Jon Peltier]

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