>> A macro that pulls source data from charts <<
When building charts in Excel 97, many users reference information in other workbooks to keep spreadsheets fairly streamlined. But what do you do if a user complains that the data source has become corrupted or that the file is no longer available in the network?
It's a little bit of a headache to read, but Knowledge Base article 137016 includes the full contents of a macro that can strip important data from the graphic elements of a chart.
http://support.microsoft.com/support/kb/ARTICLES/Q137/0/16.asp
After creating the simple VBA macro, you only need to run it and drop the information into a worksheet called Chart Data. Don't go volunteering this information to all of your users, but if a VP loses an important sales worksheet, you can pull out this nifty power trick and save the day.
It's a little bit of a headache to read, but Knowledge Base article 137016 includes the full contents of a macro that can strip important data from the graphic elements of a chart.
http://support.microsoft.com/support/kb/ARTICLES/Q137/0/16.asp
After creating the simple VBA macro, you only need to run it and drop the information into a worksheet called Chart Data. Don't go volunteering this information to all of your users, but if a VP loses an important sales worksheet, you can pull out this nifty power trick and save the day.
No comments:
Post a Comment