| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Updating charts when data source is in a different file
I have two files: data in one, chart in another. If I open the chart file,
the chart appears warped (dates appear in reverse or in numeric form, data line goes flat etc etc) unless I have the data file open, then it corrects itself. I have 50 data source documents linked into one chart file so its tough for me to have all the data files open at the same time. Anyway to make sure the chart does not adjust when I close the data source file? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| recovering chart source data from deleted files | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Automatically update from source when file opens | Excel Discussion (Misc queries) | |||
| File Error: Data May Have Been Lost | Excel Discussion (Misc queries) | |||
Threaded Mode
