Read back the source data from chart
 

Hi,
I would like to make a function to auto adjust the chart x/y-axis range/div.. by the actual data. However, may I know how VBA can trace back the source data (directly)? Also those charts are make by different data sheets (same workbook).

actually, i wrote function before, which required user to select the sheet name first, then macro will share the x/y-axis title from data sheet (seems indirect method but works) and then calculate the min/max. However, this case now is the charts from different sheet. any ideas?

thanks for your comments in advance.