清空筛选条件
清空筛选条件

How do I plot specific data from an export excel file?

3 次查看（过去 30 天）
Wong En Xin
Wong En Xin 2020-10-27
评论： Wong En Xin 2020-10-28
I have a excel file with data which contains category and value. For example: Canada---3---30, Canada---4---40, Italy---3---20
I would like to plot the data only for the country I want, I use 'location=input('location=')', and would like the graph to only show the data for the location I typed for my plot(x,y).
How should I do that? Thank you.
  1 个评论
Sudhakar Shinde
Sudhakar Shinde 2020-10-27
You can use readtable and plot / bar functions. You could add excel data example and what you have written meanwhile to achieve this question.

请先登录，再进行评论。

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

回答（1 个）

Sudhakar Shinde
Sudhakar Shinde 2020-10-27
Example:
Then you need plot of Value1 vs Value2 of country 'Canada' :
table=readtable('test1.xlsx');
Data= contains((table.Country),'Canada');
plot(table.Value1(Data),table.Value2(Data);)
  6 个评论
显示 4更早的评论
Sudhakar Shinde
Sudhakar Shinde 2020-10-28
编辑：Sudhakar Shinde 2020-10-28
country = input('Input Country: ','s');
Data= contains((table.location),country); %Filter the data with location input
plot(table.days_tracked(Data),table.total_cases(Data)); %Plot days_tracked vs total_cases
% for input location
Above code lines will serve ur purpose.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Bar Plots 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by