ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Have Linked Data Labels Adapt for an Expanded Range (https://www.excelbanter.com/charts-charting-excel/237949-have-linked-data-labels-adapt-expanded-range.html)

[email protected]

Have Linked Data Labels Adapt for an Expanded Range
 
I currently have a graph with data labels linked to cells in my worksheet.
The only problem is that when I expand the range of the graph, all the data
labels incorrectly shift. Is there anyway to have the labels adapt
dynamically or at least stay linked to the correct data point?

Adam Bush

[email protected]

Have Linked Data Labels Adapt for an Expanded Range
 
On Jul 24, 12:30*pm,
m wrote:
I currently have a graph with data labels linked to cells in my worksheet.. *
The only problem is that when I expand the range of the graph, all the data
labels incorrectly shift. *Is there anyway to have the labels adapt
dynamically or at least stay linked to the correct data point?

Adam Bush


I think you want the add-in I've been using this week

http://www.appspro.com/Utilities/ChartLabeler.htm


All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com