Hi,
I'm not fantastic on Excel but am slowly learning so apologies if this is impossible or something really simple!!
I have a pie chart that takes information from a table with formulas so that when I update the table the pie chart also updates.
Some of the data in the table has values of 0 due to the formulas, this will increase as my table collects more info over the weeks/months. I have manged to work out how to hide data labels on the pie chart with a value of 0 as it made it look very messy. What I want to do is have the data labels on the pie chart show the value and the data title from the table (names in this case) but not show the 0 or the names of the people with 0. Is this possible, does this actually make sense?!
I'm not fantastic on Excel but am slowly learning so apologies if this is impossible or something really simple!!
I have a pie chart that takes information from a table with formulas so that when I update the table the pie chart also updates.
Some of the data in the table has values of 0 due to the formulas, this will increase as my table collects more info over the weeks/months. I have manged to work out how to hide data labels on the pie chart with a value of 0 as it made it look very messy. What I want to do is have the data labels on the pie chart show the value and the data title from the table (names in this case) but not show the 0 or the names of the people with 0. Is this possible, does this actually make sense?!
