chart data labels

Hello, I have been building pie charts as well as clustered column and bar charts and am wondering if there is a way to make the data labels automatically appear/disappear with changes in the data. Specifically, if the value is 0% in a pie chart, I don't want the data label to show, but as soon...

Hi guys, I have created this book with a ton of formulas and macros within it which boils down to a line chart to compare sales of 2 objects over months dynamically. My problem is that if the sales figures for the two objects in the same month are too close to each other after entering new...

I'm trying to create a dynamic graphs based on a pivot table where slicers will be used. I'm trying to figure out a way for the data labels to be the relevant company's logo based on the slicer selections. I've figured out a way to have the labels show as dynamic to a cell, but when I select...

Hi, I have a waterfall chart and would like to put some data labels on it... What I was wondering is if it is possible to have the data labels pointing to a cell? i.e. =E6 The reason for this is that the waterfall chart sometimes crosses from negative to positive and vice versa, so the way I...

I have data. 2 columns a2:b5 each row has a different font color apple 4 banana 3 peach 2 pear 1 I want the label in a chart to march the font color of the source cell So in a chart I'd have 4 labels: "apple" "banana" "peach" "pear" I can't see...

Hi - I've got a 2003 workbook with about 40 charts. Our office is converting to 2010 and i've been testing the 2003 in 2010. I'm finding that the charts are coming over correctly, but on each chart 1 (out of 6) of the Data Labels is not displayed correctly. The formatting is correct, but the 1...