Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't vlookup read newly entered data from a source file? | Excel Discussion (Misc queries) | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Pivot table: hyperlink back to source data | Excel Discussion (Misc queries) | |||
External Data Source updating on open, how to turn back on prompt. | Excel Worksheet Functions | |||
How to read a SQL Table into Excel change the data and write back into SQL | Excel Programming |