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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
chart errors
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. Can anyone help? |
#3
|
|||
|
|||
Thanks Tushar for the input. As I said in my original message, all charts,
including the X & Y axis' are formated identically. The other 24 charts updated from the other 11 spreadsheets as I expected. It is only a problem with these 4 charts from this one spread sheet. To answer your question about the values; no, they are not manually set. all charts are linked to values from the same source. Thanks again for your input. This is a strange one. Regards Rich "Tushar Mehta" wrote: For those charts that do not update, are the x or y-scales set to manually specified min/max values? Double-click the x-axis then check the Scale tab. Do the same for the y-axis. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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. Can anyone help? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo charts: stack bar with target line | Martin James Thornhill | Charts and Charting | 8 | October 3rd, 2008 04:22 PM |
resizing chart title box Excel 97 | Andy Pope | Charts and Charting | 1 | February 28th, 2004 03:26 AM |
Pivot Chart affected when refresh data | Ailing | Charts and Charting | 1 | January 15th, 2004 11:20 AM |
Printing Text Boxes with a chart | Jon Peltier | Charts and Charting | 1 | January 12th, 2004 01:51 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |