how to plot table to line graph with dots ?

hi guys, i have data from the table as picture below. I want to make line graph from data table which X-axes as 'U1' and Y-axes as 'GlobalFx'.

how to plot ?

Answer 1

[Star Strider]

There are easier ways to import the table using detectImportOptions, however since it exists as posted, try this —

x = str2double(strrep(pushovertable.U1, ,',','.'))

y = str2double(strrep(pushovertable.GlobalFX,',','.'))

figure

plot(x, y, '.')

grid

.

.

[Dyuman Joshi]

You could perform that operation on the whole table and then use indexing to plot directly from the table.

Answer 2

[Dyuman Joshi]

Convert the data to double data type, and use indexing to plot the data (Reference for syntax - https://in.mathworks.com/help/matlab/ref/plot.html#d126e1185592)

Answer 3

[Image Analyst]

Your numbers have commas in them instead of decimal points. That's probably why it reads them in as character arrays instead of doubles. What are your operating system regional settings? Can you change them so that it reads in the numbers as numbers?

Otherwise loop over those values using str2double to convert them to doubles.

strGlobalFX = pushovertable.GlobalFX(2:end);
strU1 = pushovertable.U1(2:end); % Skip missing first row
for row = 1 : numel(strGlobalFX)
    str = strrep(strGlobalFX(row), ',', '.'); % Convert comma to decimal point.
    GlobalFx(row) = str2double(str); % Convert to number
    str = strrep(strGlobalFX(row), ',', '.'); % Convert comma to decimal point.
    U1(row) = str2double(str); % Convert to number    
end
plot(U1, GlobalFX, 'b-');
xlabel('U1')
ylabel('GlobalFx')
grid on;

Answer 4

[Fangjun Jiang]

plot(pushovertable.("U1"),pushovertable.("GlobalFX"))