Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I have a chart with data labels and for an unknown reason the chart stopped updating. It's not a dynamic chart and the data series are all correct and should update. What I ended up doing was reinputting the same data ranges and although they were exactly the same as before, the chart now updates. However, the updated chart has lost the data labels. I have a backup chart with exactly the same data that still contains the labels.
Because there are many data points on the chart, it's very difficult to select the correct data point to add a label. Is there any way of importing/copying the data labels from the previous chart?
If this is possible (presumably with VBA) I'd be happy to upload the chart and data.
Thanks!
I have a chart with data labels and for an unknown reason the chart stopped updating. It's not a dynamic chart and the data series are all correct and should update. What I ended up doing was reinputting the same data ranges and although they were exactly the same as before, the chart now updates. However, the updated chart has lost the data labels. I have a backup chart with exactly the same data that still contains the labels.
Because there are many data points on the chart, it's very difficult to select the correct data point to add a label. Is there any way of importing/copying the data labels from the previous chart?
If this is possible (presumably with VBA) I'd be happy to upload the chart and data.
Thanks!