A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Charts Linked to Spreadsheets



 
 
Thread Tools Display Modes
  #1  
Old June 30th, 2005, 06:08 PM
Rich
external usenet poster
 
Posts: n/a
Default Excel Charts Linked to Spreadsheets

I have a file of 28 charts that is linked to 12 spreadsheets utilizing the
“source data” function within Excel. The spreadsheets are updated weekly (at
a minimum). When the chart files are opened, a pop-up asks if you want the
charts to update or not. I select the “update” option to update the charts
with the new data from the spreadsheets. This particular set of data was
entered on 6/22 and then again on 6/29. When I updated the charts, they all
updated with the new data with the exception of 4 charts linked to one
spreadsheet. All 24 other charts linked to the other 11 spreadsheets
displayed the 6/29 data. The 4 charts only show data to the 6/22 date, even
though the spreadsheet includes the 6/29 data.

I have checked all formulas associated with these charts and they are
formatted exactly as the formulas that updated. When the “source data” is
opened and the series is viewed, it encompasses (dotted line circling the
data column) the 6/29 data. I can see no logical reason for this one
spreadsheet not to update the 4 charts.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Excel Charts?? JDS Powerpoint 3 April 8th, 2005 09:42 PM
Windows in Taskbar Chevy General Discussion 8 October 15th, 2004 03:57 PM
Colors Vanishing on Linked Excel Charts Ron Russell Powerpoint 2 September 21st, 2004 09:23 PM
Excel creates its own hidden charts that creates a corrupt file! FlawedLojik General Discussions 0 August 29th, 2004 05:43 PM
Coverting Lotus 123 files to use with excel Muffin1947 General Discussion 6 June 20th, 2004 10:18 AM


All times are GMT +1. The time now is 02:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.