Hide Labels with zero values in a Graph

[Taislin]

Hi... i'm dealing with a problem here...
I'm creating a simple graph with values earned in each month, but i have all 12 month and ofcourse there are lots of months that are still at zero value. So how do i supress them from showing in the graph?. By other mean, i want the graph to show only labels in x axis that haves values diferent from 0 in y axis.
I added a sample workbook where i have letters from A to J with values and E, F and I have zero values. So i want E, F and I to dissapear from x axis. Is this possible?
Thank you.

[Melvinrobb]

You can copy column C, and paste it in column B.
Then put this formula in C5 and drag down:

Please Login or Register  to view this content.

[Taislin]

This makes the label disappear indeed, but i didn't made myself clear....
I need it to really disappear from the graph. Like shorten the graph automaticaly...
So if the value is zero, the space from graph dedicated to E, F and I value disappear.
This way the label disappears, but the empty space stays between the graph :/

I can supress zeros using dynamic table, but have to do this every time i update the values in the table, so i need something that do this automaticaly, so everytime i update the values, the graph hides zero values labels and space or show them again if value is diferent of zero.
Thank you