How to plot 3 column values in matlab from an excel sheet?

Question

marie lasz 2021-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/812610-how-to-plot-3-column-values-in-matlab-from-an-excel-sheet

评论： marie lasz 2021-4-27

Hey all,

I need to plot 3 column values from excel. For example; one column contains different images, second column contains its SSIM values and third column contains different keys. on x-axis it should have keys column, on y-axis SSIM values. Can anyone guide me how to do that?

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2021-4-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/812610-how-to-plot-3-column-values-in-matlab-from-an-excel-sheet#answer_686020

在 MATLAB Online 中打开

sample data.xlsx

Try this:

% Demo by Image Analyst.
clc;    % Clear the command window.
fprintf('Beginning to run %s.m ...\n', mfilename);
close all;  % Close all figures (except those of imtool.)
clearvars;
workspace;  % Make sure the workspace panel is showing.
format short g;
format compact;
fontSize = 20
data = readmatrix('sample_table.xls')
qualityFactor = data(:, 1);
[rows, columns] = size(data)
legendStrings = cell(columns - 1, 1);
for col = 2 : columns
	thisColumn = data(:, col);
	plot(qualityFactor, thisColumn, '.-', 'LineWidth', 2, 'MarkerSize', 30);
	grid on;
	hold on;
	legendStrings{col-1} = sprintf('Image %d', col - 1);
end
legend(legendStrings, 'Location', 'southwest');
title('SSIM vs. Quality Factor for Different Images', 'FontSize', fontSize);
xlabel('Quality Factor', 'FontSize', fontSize);
ylabel('SSIM', 'FontSize', fontSize);
fprintf('Done running %s.m\n', mfilename);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

marie lasz 2021-4-27

Thank you . Thta is the thing I need.

请先登录，再进行评论。

Answer 2

Image Analyst 2021-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/812610-how-to-plot-3-column-values-in-matlab-from-an-excel-sheet#answer_684180

在 MATLAB Online 中打开

data = readmatrix('my dexcel data.xlsx.')
ssimValues = data(:, 2); % SSIM values are in column 2
keyValues = data(:, 3); % Key Values are in column 3
plot(keyValues, ssimValues, 'b.-', 'LineWidth', 2, 'MarkerSize', 12);
grid on
xlabel('Key Values', 'FontSize', 20);
ylabel('SSIM Values', 'FontSize', 20);

4 个评论
显示 2更早的评论隐藏 2更早的评论

Image Analyst 2021-4-26

You keep forgetting to attach 'my dexcel data.xlsx.' Please do so with the paper clip icon.

Since each row is one image, and column 2 has it's ssim and column 3 has its keyValue, how can you get an entire curve for a given image rather than just a single point??? What do the axes in your sample graph above represent???

marie lasz 2021-4-27

编辑：marie lasz 2021-4-27

sample_table.xls

the image posted above is taken from a paper where y-axis defines Normalized correlation and x-axis defines quality factor of jpeg compression. Now in my case for example , for every image i have different SSIM against different Q.F. here q.F are same for every image but their SSIM values are different for every image. Sample excel data is attached below;

请先登录，再进行评论。