Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Charts not updating
I am having a strange issue with excel and hope that someone can help
- The charts within a spreadsheet do not update when the source data is updated. This is a new problem as previously the updating worked fine. The spreadsheet is set to auto calc but the word "calculate' shows up in the bottom bar as if the manual calculation setting were on. But the auto calc is working as data on the sheet is updated as i change other entries. I have multiple charts on the same sheet and none of them auto update. The charts also refer to the correct data field and they do update if i select a series and click on the formula bar and then hit enter, however only the data series that i selected will update. I have to do each one individually in order to get the entire chart to update. Another thing, if i do a save there is no update but if i do a save as the chart updates to whatever the current data is, then there are not further auto updates. Thank for your help Victor |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Charts not updating
I've seen charts update when you save and reopen, but I'm not sure why.
Maybe someone else can help there. -- HTH, Barb Reinhardt "vitorjose" wrote: I am having a strange issue with excel and hope that someone can help - The charts within a spreadsheet do not update when the source data is updated. This is a new problem as previously the updating worked fine. The spreadsheet is set to auto calc but the word "calculate' shows up in the bottom bar as if the manual calculation setting were on. But the auto calc is working as data on the sheet is updated as i change other entries. I have multiple charts on the same sheet and none of them auto update. The charts also refer to the correct data field and they do update if i select a series and click on the formula bar and then hit enter, however only the data series that i selected will update. I have to do each one individually in order to get the entire chart to update. Another thing, if i do a save there is no update but if i do a save as the chart updates to whatever the current data is, then there are not further auto updates. Thank for your help Victor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically updating charts | Charts and Charting in Excel | |||
Updating Charts | Charts and Charting in Excel | |||
updating pie charts | Excel Discussion (Misc queries) | |||
updating charts automatically | Charts and Charting in Excel | |||
Updating charts in Excel | Charts and Charting in Excel |