Reading through an existing chart

[mchow2469]

Hi,

I am wondering what is the best way to read through an existing chart. For example, lets say I have a chart on my worksheet:

A B
1 5
2 6
3 7
4 8

How would I go retrieve each element in that order?
I am new to VBA, so syntax might be a problem. Thank you very much!

[mchow2469]

I have yet another question.

Is there a way in VBA to read and save objects in an existing .xls file and printing them to another?
For example, I have an existing .xls file with charts and graphs. Is there a way to read each chart and graph, and print them out into another .xls file?

I have searched everywhere if this is possible, but can not find an answer. Thanks!