I have seen this post: http://chandoo.org/wp/2009/01/29/colors-in-excel-chart-labels-trick/
And really like it, except I am using linked sources for the information in the data label and it doesn't seem to format when you do this.
Bascialy, I have sales $'s data but want to show the % change year over year as a data label. I would like to show the data label as red or green depending on if it is negative or positive change. I have used this method to link the values: http://chandoo.org/wp/2010/05/05/change-data-labels-in-charts/
If I could combine both posts, this would be great.
And really like it, except I am using linked sources for the information in the data label and it doesn't seem to format when you do this.
Bascialy, I have sales $'s data but want to show the % change year over year as a data label. I would like to show the data label as red or green depending on if it is negative or positive change. I have used this method to link the values: http://chandoo.org/wp/2010/05/05/change-data-labels-in-charts/
If I could combine both posts, this would be great.