Corrplot function : setup Variable name

I am using the function corrplot reading a matrix in one Excel file.

The first row of the Excel file contains the name of Variables that I would like to see on the left and down of the result plot.

Instead I see: Var1 Var2 .....

Please someone can help me to unserstand how to define the name of Variables on the Excel file ? Or how I can prepare a text data file ?

Thanks.

Nicola

[Voss]

Please share the code you are using to read the Excel file.

[Nicola Lisi]

Simple two lines of code:

   data = xlsread("myExcelFile.xlsx");
    corrplot(data);

As I wrote,the first row of Excel file contains the variable name.

Answer 1

[Walter Roberson]

T = readtable("myExcelFile.xlsx");
data = table2array(T);
vars = T.Properties.VariableNames;
corrplot(data, 'varNames', vars)

[Khanh Dang]

Hi Walter Roberson,

Please help me how to change the fontsize and color of subplots in the correlation matrix which is plotted by corrplot function?

I need a help immediately, I am on roadblock to complete report now.

Thanks advance!

Answer 2

[Nicola Lisi]

Thanks a lot for the suggestion !!!

Regards and Happy New Year !!!