Hi,
I have a problem while creating chart and searched the internet for solution. Found that many ppl are having the same problem but didn't find a solution that suits my needs.
I have a chart whose range contains of formulaes. I have used formulae to evaluate to blank (="") in certain scenarios.
When i am creating a graph (bar graph) showing data labels, the corresponding bar shows the value as 0 instead of blank.
I know that if i include a blank cell (truly blank, not =""), the data label won't show any value but this isn't happening in case of ="".
Is there any way i can show the data label as:
0 - If the cell equates to 0,
blank - if the cell equates to =""
I have a problem while creating chart and searched the internet for solution. Found that many ppl are having the same problem but didn't find a solution that suits my needs.
I have a chart whose range contains of formulaes. I have used formulae to evaluate to blank (="") in certain scenarios.
When i am creating a graph (bar graph) showing data labels, the corresponding bar shows the value as 0 instead of blank.
I know that if i include a blank cell (truly blank, not =""), the data label won't show any value but this isn't happening in case of ="".
Is there any way i can show the data label as:
0 - If the cell equates to 0,
blank - if the cell equates to =""