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
|
|||
|
|||
Excel 2007 Chart auto update not working
Every other worksheet my charts auto update, except one. Of course it's one
that changes often... the data on the chart sheet updates, but the chart doesnt. I checked all the settings and they're right. Frustrating! |
#2
|
|||
|
|||
Excel 2007 Chart auto update not working
I have the same problem. I have a workbook in Excel 2007 (SP1) where three
charts are displayed (automatic calculation selected). Only one of them auto updates when the source data that it is utilizing changes. The other two don't auto update. When I look at the source data in the chart, it shows that it is getting the data through a regular cell reference. Excel does show the first couple values in the series in parentheses next to the cell reference, but they are not the right #s -- the series values somehow are not being updated in the chart when the values change. Questions -- Why don't they all auto update? (they are created through VBA code the exact same way) Is Microsoft going to address this issue in the upcoming Service Pack fix? How do I force a chart to auto update as a workaround? If anyone can help me out, I would be very appreciative. "DeniseW" wrote: Every other worksheet my charts auto update, except one. Of course it's one that changes often... the data on the chart sheet updates, but the chart doesnt. I checked all the settings and they're right. Frustrating! |
Thread Tools | |
Display Modes | |
|
|