Read back the source data from chart

D

danny tang

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 sourcedata (directly)? Also those charts are make by different data sheets (sameworkbook).

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 (seemsindirect 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top