How to remove result from bar chart which contain "0"

Is this what you wanted?

if so, then i will explain what I did.

What do you mean by this:

is it possible to filter the chart data and deselect "0"?

In what way does my approach NOT do what you want?? In effect, it is using two formulae and 2 named ranges to deselect the zero values.

There is not.

Do you need an explanation of what I did?

OK.

M3:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$21)/(INDEX($B$2:$D$21,,MATCH($F$3,$B$1:$D$1,0))>0),ROWS(M$3:M3))),"")

Red: selects the column range defined by F3.
Cyan: when the values in that column range are >0
Green: the row number is returned
Purple: in order smallest to largest
Blue: starting from 1st smallest, then 2nd smallest, etc,
Black: fianlly returning the corresponding value from column A.

N3 is a straightforward INDEX-MATCH. No need to explain.

To make the chart axes dynamic, I used two Named ranges (CTRL-F3)

Place:
=Conclusion!$M$3:INDEX(Conclusion!$M:$M,MATCH("Zzzz",Conclusion!$M:$M))

Data:
=Conclusion!$N$3:INDEX(Conclusion!$N:$N,MATCH(10^300,Conclusion!$N:$N))

These dynamically adjust the range selected to go from the starting cell (M3 or N3) to the last non-blank value in the column.

To make these Named Ranges work with a chart, the file&sheet name needs to be included as well. So. CHART DESIGN/Select Data/series 1/Edit and you will see that I have refered to the X an Y axes, not as a cell reference range but as:

='Hide 0 from chart (1).xlsx'!Place

and
='Hide 0 from chart (1).xlsx'!Data

That passes only the dyanmically selected data to the chart. Job done.


You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.