matLAB Gui Query Excel

filename = 'HE_Data.xlsx';
sheet = 1;
xlRange = 'H10:AB10';
num = xlsread(filename,sheet,xlRange,'basic');

fname = {'Agriculture and related subjects','Architecture Building and Planning','Biological Sciences','Business and Administrative studies','Computer Science','Creative Arts and Design','Education','Engineering and Technology','Geographical Studies','Historical and Philosophical studies','Initial Teacher Training','Languages','Law','Mass Communications and Documentation','Mathematical Sciences','Medicine and Dentistry','Social Studies','Physical Sciences','Subjects allied to Medicine','Veterinary Sciences','Combined'}; 
x = 1:21; y = (num);
bar(x,y)
set(gca, 'XTick', 1:length(fname),'XTickLabel',fname);
xtickangle(90)
title('Aston University - Entrants in Each Field of Study')

[Image Analyst]

Try this link

[John Smith]

wow thanks here it is:this is the error im recieving. I tried the code from https://uk.mathworks.com/help/matlab/ref/xlsread.html

[Geoff Hayes]

John - what is the error that you are receiving? Or is it the error that your bar graph looks like the above? What should it look like? What can you tell us about the

num = xlsread(filename,sheet,xlRange,'basic');

data?

[John Smith]

well the data should be similar to this for example:

y = [0,60,60,30,100,60,0,120,0,0,0,0,0,0,0,0,10,0,0,0,0];

thats inputed manually. I want to read those digits from the excel file which i tried doing but

it just shows the y axis starting from 0 to 1 instead of what it should be.

xlRange = 'H10:AB10'; is the cell range with those numbers in each cell.

[Geoff Hayes]

so it should be similar to the above data, but what are you really reading in?

[John Smith]

these numbers from cell H10 to Ab10. some are blank aka 0. ive attached document have a look (HE_Data.xlsx)