View Single Post
  #1  
Old February 18th, 2006, 03:57 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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!