S
SM
Hi,
I'm having problems with certain data labels on columns within a chart,
where the column reflects the correct data, but the data label contains the
incorrect value. The value is the previous value of the chart before the
data series were changed.
Here's some background info that may or may not help explain why this is
happening. I started with a worksheet containing 10 charts (5 line and 5
column), which worked great. This worksheet served as a template for 9 more
worksheets, each containing the same 10 charts, linked to different data
series. There weren't any issues copying these initally, but towards the
last 8, 9 or 10 worksheets, the values on the final data point of each column
chart would not update.
I've tried closing the file in the hope it would refresh the data, but that
didn't help. I'm not sure where to look next! Any suggestions or help would
be appreciated!
Thanks,
Sean
I'm having problems with certain data labels on columns within a chart,
where the column reflects the correct data, but the data label contains the
incorrect value. The value is the previous value of the chart before the
data series were changed.
Here's some background info that may or may not help explain why this is
happening. I started with a worksheet containing 10 charts (5 line and 5
column), which worked great. This worksheet served as a template for 9 more
worksheets, each containing the same 10 charts, linked to different data
series. There weren't any issues copying these initally, but towards the
last 8, 9 or 10 worksheets, the values on the final data point of each column
chart would not update.
I've tried closing the file in the hope it would refresh the data, but that
didn't help. I'm not sure where to look next! Any suggestions or help would
be appreciated!
Thanks,
Sean