How to create bar graph with formula and have nan in the import excel?

Hi, I want to create bar graph by using Matlab GUI. The result shows that the 2 bar graph shows and the 2 other bar graph with nan didnt show (RES, LES).The attachment shows the coding & the excel file. Please help.

[Shahirul Ashraf]

please help.

Answer 1

[KSSV]

Read about fillmissing. You can fill the gaps/ NaN's using that function.

[Shahirul Ashraf]

I dont want to put any value in the NaN. It means before NaN is the last number. If put the fillmissing, the NaN will have value, which is effect the formula that i have written.

[KSSV]

So what you want to do?

[Shahirul Ashraf]

It means that i dont want to include NaN. The reading stop before NaN.

In my formula, there is x*y & total of every row x*y;

if there is NaN it will not show the result, x*NaN=not shown

If there is zero it will effect the result as zero, x*0=0

[KSSV]

A = [NaN 1 2 NaN NaN 3] ;
A(isnan(A)) = []

A = 1×3

1 2 3

You can remove the NaN's using the above line.

[Shahirul Ashraf]

i have try this before, not work.