Names on x-axis in the excel file

1 visualizzazione (ultimi 30 giorni)
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 Commenti
Ankit
Ankit il 13 Set 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 il 13 Set 2022
Modificato: muhammad choudhry il 13 Set 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.

Accedi per commentare.

Risposta accettata

Walter Roberson
Walter Roberson il 13 Set 2022
plot( categorical(names), values)

Più risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by