This link was exactly what I was looking for! Thank you so much.

If you can do this last step then great, but if not you've already been so
helpful.

Is it possible for you to always select the same chart from a partficular
sheet?
For example, the active chart is always in "sheet4" No other charts ever
exist in "sheet4".

thanks!

Curt J
"JLatham" wrote:

In case I missed the mark entirely, perhaps this link will help you:
http://support.microsoft.com/kb/300643
Article (with code) title: Macro to extract data from a chart in Excel


"Curt J" wrote:

I have a chart that is automatically produced from Cognos. I export the data
into Excel, but the data for X and Y axis is contained in the chart. How do
I export that data into a spreedsheet?