Dear all,
I have a file with two sheets one with the data (example below) that gets filled out of matlab and one sheet that presents a scatter chart of the data with various lines (in the legenda a through e). It's possible that randomly one of the columns with the data has only zero's/no data see the example below like the column 'c'.
a b c d e
1 1 0 1 1
2 2 0 2 2
3 3 0 3 3
4 4 0 4 4
5 5 0 5 5
Is there a possibility without doing this manually hide the 'c' column from the legenda when the excel file is automatically filled by matlab.
Tnx for any help
Bookmarks