Suppressing zero values AND column axis labels in Bar charts

So…..I have a very simple Excel 2010 table

Label 1 50
Label 2 60
Label 3 0
Label 4 0
Label 5 20
Label 6 0
Label 7 80

…and I want to create a very simple Bar Graph, but I want the graph to avoid plotting data *AND* the labels (Column Axis) where the data is zero.

I’ve found ways to suppress the zero values and avoid the Label appearing, but there are still gaps in the chart corresponding to the places where the blanks are.

Chart 2.jpg

Is it possible to avoid the gaps while still retaining the ability to include the other Labels and their values, should they change.?

Chart 3.jpg

I can achieve a similar affect with a Pie chart, but it doesn't suit my needs.

Help anyone? Thanks!

Thanks for this....it was really helpful (and simple)

Because of the complexity of the data and graphs I am creating, I have the data on a separate sheet to the graph.

I have set the Filter to show anything greater than zero, and I also incorporated another tip in the form of the following code on the data tab to ensure the filter auto-updates

Private Sub Worksheet_Activate()
ActiveSheet.AutoFilter.ApplyFilter
End Sub

However.....I find I actually have to visit the Sheet where the data is located before everything updates.
This is not actually a big issue as I have a macro that I have added a couple of lines to in order to force this, but is there a better way?

Regrettably - no .... apart from the fact that it's huge and complex it also contains confidential information. This is a tiny part of bigger beast.

If I can find time I'll extract a subset and post it. In the meantime I'll continue with my little workaround, I don't mind it but its not very elegant, so if anyone has any ideas, I'd appreciate some pointers.

Thanks.

Thanks Andy - I've never used Name Manager but it seems it's part of the solution.

I will dissect and incorporate.