Take out the zeros in my chart

[holy_eti]

Hello everyone,

In my excel, I have some charts that have zeros in their values range. I would like to "hide" those datas. I've tried two methods but none works. First of all, go on my chart option, in design/select data/ hidden and empty cells / select either gaps or zeros. My zeros values still are in the Chart. In second, I tried to do an IF formula where when my value is zeros, it doesnt appear in my column so my chart would not take car of it. Sadly, it doesnt work and my chart still takes care of it...
Does anybody have a better Idea?
Thankss

 

[Oaktree]

Try using an IF formula, but instead of setting the value to 0 or "", set it to NA()

e.g. =IF(A2=0,NA(),A2) copied down and use that new column as the data source for your chart.

 

[Fluff]

@holy_eti
Is this the same question as https://www.mrexcel.com/forum/quest...valeurs-nulles-dun-graphique.html#post5081948

 

[holy_eti]

Yes, I accidently wrote it in my native language thinking I was on a French server, that was my mistake and I apologize for that..

 

[holy_eti]

I've just tried, it isn't working.. I have the same results that I had previously

 

[Oaktree]

I'm assuming you have a line graph.

If that's the case, you have three options:
Option 1: a 0 or a ="" formula will plot as a 0 value
Option 2: a purely blank cell (i.e. no formula) will not plot. Instead, you'll get a break in the chart.
Option 3: an #N/A value will draw a straight line to connect the points on either side, essentially pretending that data point does not exist.

 

[holy_eti]

I do have a line graph. First two options are not working for me, I'll try the third one, thank you for your help!

 

[holy_eti]

My problem is solved, thank you @Oaktree