Stresbringer
Board Regular
- Joined
- Mar 16, 2006
- Messages
- 84
Hi,
Ive been trying to do this all day now, Ive tried looking thought the posts but i cant seem to find ( or understand the answer). Basically i am doing a dynamic pie chart of leaving reasons for employees. I have a list of all possible reasons and a count for each reason linked from another sheet in the next column.. Obviously some reasons do not yet a value but i need to keep it showing on the table.
I can do the chart easily, However all reasons with a zero or no value still appear on the Legend which i do not want to happen until that particular reason has a value.
I have read changing it to NA(), "", and 0 however none of these work for m. They still show on the chart and legend , Either as a blank name or a #N/A name, its driving me nuts!!
I have checked in the options > chart > plot empty cells. However it is shaded.
I have read earlier that someone used the offset function to do this, however i am unfamiliar with this so do not know how it works can someone explain it ? simple terms
Surely there must be an easy way ?
Any help is much appreciated.
Ive been trying to do this all day now, Ive tried looking thought the posts but i cant seem to find ( or understand the answer). Basically i am doing a dynamic pie chart of leaving reasons for employees. I have a list of all possible reasons and a count for each reason linked from another sheet in the next column.. Obviously some reasons do not yet a value but i need to keep it showing on the table.
I can do the chart easily, However all reasons with a zero or no value still appear on the Legend which i do not want to happen until that particular reason has a value.
I have read changing it to NA(), "", and 0 however none of these work for m. They still show on the chart and legend , Either as a blank name or a #N/A name, its driving me nuts!!
I have checked in the options > chart > plot empty cells. However it is shaded.
I have read earlier that someone used the offset function to do this, however i am unfamiliar with this so do not know how it works can someone explain it ? simple terms
Surely there must be an easy way ?
Any help is much appreciated.