how to plot like this

Sample data

April19 [ 1 2 3....30 31] % days

Kwh = [ 40 43 44...40 41]

May19 [ 1 2 3....30 31] % days

Kwh = [ 39 43 42...41 42]

.

.

.

March20 [ 1 2 3....30 31] % days

Kwh = [ 50 49 40...45 44]

[Walter Roberson]

Have you already read in the data? Into a cell array?

[Afsher P A]

My data attached with excel file

Answer 1

[Image Analyst]

Try this:

data = readmatrix('data.xlsx')
months = {'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'};
[rows, columns] = size(data)
for k = 1 : 2 : columns
	plot(data(:, k), data(:, k+1), '.-', 'LineWidth', 2, 'MarkerSize', 20);
	hold on;
end
fontSize = 18;
xlabel('Day', 'FontSize', fontSize);
ylabel('kWh', 'FontSize', fontSize);
grid on;
legend(months);

[Afsher P A]

clear; close all; clc
data = readmatrix('data.xlsx')
months = {'April19', 'May19', 'Jun19', 'Jul19', 'Aug19', 'Sept19', 'Oct19', 'Nov19', 'Dec19', 'Jan20', 'Feb20', 'Mar20'}
[rows, columns] = size(data)
for k = 1 : 2 : columns
	plot(data(:, k), data(:, k+1), '.-', 'LineWidth', 2, 'MarkerSize', 20);
	hold on;
end
fontSize = 18;
xlabel('Day', 'FontSize', fontSize);
ylabel('kWh', 'FontSize', fontSize);
grid on;
legend(months);