How to load excel columns under same variable file
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Yellow Canary
el 12 de Sept. de 2015
Comentada: the cyclist
el 12 de Sept. de 2015
I have an excel file it has 2 columns of data. When I import this file to Matlab, each column shown as a different file. (ex: VarName1 and VarName2) I want to show them under the same file. I want to plot them to Bar3 plot. When they are separate, I can't show them on the same plot. I want to plot a graph like this example http://www.mathworks.com/help/matlab/ref/bar3.html
0 comentarios
Respuesta aceptada
the cyclist
el 12 de Sept. de 2015
One possible solution is to just concatenate the two variables into one array:
VarName1 = rand(7,1);
VarName2 = rand(7,1);
figure
bar3([Varname1; Varname2])
2 comentarios
the cyclist
el 12 de Sept. de 2015
Clicking "Accept this Answer" is the best form of thanks (and may help guide future users with a similar question).
Más respuestas (1)
the cyclist
el 12 de Sept. de 2015
If you use the Import Data tool (located in the Command Window), you can specify that you want to import into one variable, rather than separate columns. You can also have it generate code for you to do the import.
0 comentarios
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!