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!
Bookmarks