hmmmidk220
Board Regular
- Joined
- Dec 14, 2016
- Messages
- 55
Is this possible?
I have a bar graph with Costs on the x axis and values on the y axis. Cost 2 (the 2nd x axis label) has a zero value while all the other x axis labels have non zero values. I want cost 2 to be automatically hidden when there is a zero value for it.
I know I can manually hide it, but I'm looking for an automatic solution. I've spent hours online looking for a solution, but can't find anything that works. I don't want to use VBA, as I don't want other people that use it to have to worry about running code. I've read that #N/A seems to be ignored by excel but I can't get that to work (the x axis label always stays there)
Is this possible in excel 2010???
Thank you!
I have a bar graph with Costs on the x axis and values on the y axis. Cost 2 (the 2nd x axis label) has a zero value while all the other x axis labels have non zero values. I want cost 2 to be automatically hidden when there is a zero value for it.
I know I can manually hide it, but I'm looking for an automatic solution. I've spent hours online looking for a solution, but can't find anything that works. I don't want to use VBA, as I don't want other people that use it to have to worry about running code. I've read that #N/A seems to be ignored by excel but I can't get that to work (the x axis label always stays there)
Is this possible in excel 2010???
Thank you!