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