Names on x-axis in the excel file

3 visualizaciones (últimos 30 días)
muhammad choudhry
muhammad choudhry el 13 de Sept. de 2022
Comentada: muhammad choudhry el 13 de Sept. de 2022
Hi,
I am having trouble in plotting, I want to plot the graph where x-axis are names and y-axis numbers but I am getting the error below. what is solution for that.
Code:
close all; clear all; clc;
file = ["C:\Users\Alphagamma\alphagamma.xlsx];
for i = 1:numel(file)
a=readtable(file(i));
names = a{:,3}
values = a{:,5}
end
figure()
plot (names,values)
Error:
>> figure()
plot (names,values)
Error using plot
Invalid data argument.
  2 comentarios
Ankit
Ankit el 13 de Sept. de 2022
You can only plot numeric data. But x label you can change with the help of xTickLabels
set(gca, 'xTickLabels', XlabelStr);
muhammad choudhry
muhammad choudhry el 13 de Sept. de 2022
Editada: muhammad choudhry el 13 de Sept. de 2022
Hi,
what am I doing wrong here I added the piece of code you mentioned!
is there no way it will read the names from the excel ?
Code:
set(gca, 'xTickLabels', names);
figure()
plot (names,values)
Error:
plot (names,values)
Error using plot
Invalid data argument.

Iniciar sesión para comentar.

Respuesta aceptada

Walter Roberson
Walter Roberson el 13 de Sept. de 2022
plot( categorical(names), values)
  1 comentario
muhammad choudhry
muhammad choudhry el 13 de Sept. de 2022
that's it, sweet short and simple! Thanks alot.

Iniciar sesión para comentar.

Más respuestas (0)

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by