Data Labels - How to have label move with data

[MIGHTYJOE028]

I have a chart based on two columns of data - % of total and the actual dollars. I have the chart show the bars as a % of total. However, my data labels point to the actual dollars so these are based on a formula reference to the cells containing that data. This is referencing a pivot table so when the pivot table change (i.e. change the region that will display on the graph) the data labels do not move. So one data label may be high on the graph, but the data is now at the bottom.

Any suggestions?

 

[MIGHTYJOE028]

I think I'm good. Working on a few solutions. This can be deleted, but not sure how...

 

[Jon Peltier]

Actually, rather than deleting your question, write up how you solved it. Then some future user might find your question in a search, and have your answer right there.