Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 does not update chart data | Charts and Charting in Excel | |||
Auto-update in Excel 2007 | Excel Discussion (Misc queries) | |||
Update chart with new row - not working in 007 | Charts and Charting in Excel | |||
Excel 2007 - How do I quickly update a chart using Source data? | Charts and Charting in Excel | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |