Plot Multiple Time Series Based on Individual Condition

4 次查看（过去 30 天）

Dima 2011-9-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/15871-plot-multiple-time-series-based-on-individual-condition

Hello Friends!

I am somewhat new to scientific charting) more accustomed to working in Excel, but I think I have run into its limitation as regards to charting…I am not sure if Matlab can do the following…

1) Take the time series data from excel, each data series will have three describers (first three rows of each column) – COLOUR, TYPE and THICKNESS 2) plots each time series data in such a way as: a) colors the time series according to a time series criterion (eg. 1 for red, 2 for black) b) allows to adjust the thinness of the plotted series based on another criterion (e.g. 10 very thick, 2- close to hairline) c)Sets the type of the trendline to dashed/solid (based on the Type criterion)

I can send an example worksheet if necessary..

Thanks for your time!) I will be glad to hear any opinion.

Dima

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

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2011-9-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/15871-plot-multiple-time-series-based-on-individual-condition#answer_21519

在 MATLAB Online 中打开

You may wish to create some cell arrays to help:

colors = {'r', 'k', 'g'};  %red, black, green
linetypes = {'--', '-'};   %dashed, solid
% ....
thislinespec = [colors{column1}, linetypes{column2}];
thisthick = column3;
plot(x, y, thislinespec, 'thickness', thisthick);

12 个评论
显示 10更早的评论隐藏 10更早的评论

Walter Roberson 2011-9-14

When you have variable amounts of data, it is easier parse if you put the constant part first and then the variable stuff. Thus I would suggest you move the words 'COLOUR' and 'TYPE' and 'THICKNESS' to be the first thing on their lines.

I gather that after that, the first thing on the line is a time, and the remaining items are the values of each of the time series at that time? Is there ever any missing data, and if so how is it indicated?

And to cross-check: you have 4 time series in that file? Or is the trailing 0 on the lines just to match the number of columns in the first 3 lines? If that is the case, is the initial 1 on the first three lines so that that information will sort first? And if so, if the data is being sorted, is the order of the 3 headers? If the initial 1 is to get the headers to sort first, would there not be a risk that some of the data lines might sort before the headers because their times happened to be earlier than "1" ? If you do for some reason need a constant "1" at the beginning of the header lines, then I would suggest moving the keyword to the second position unless there is a technical reason not to.

Walter Roberson 2011-9-15

Fangjun, 'thickness' refers to the thickness of my head when I'm working on too many things at one time ;-(

Dima 2011-9-15

yeah))) thickness must refer to the linewidth)))) Walter hopefully)) your head linewidth will go back to normal)))) Maybe then you can still help me create this kind of code that can build upon later...thanks!

请先登录，再进行评论。

更多回答（2 个）

Fangjun Jiang 2011-9-14

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/15871-plot-multiple-time-series-based-on-individual-condition#answer_21517

在 MATLAB Online 中打开

Yes, all is pretty straightforward in MATLAB. You can type help plot or doc plot in MATLAB for more information. Try this example for yourself.

figure;hold on
plot(1:10,'r','linewidth',10)
plot(rand(10,1),'g--')

Code below applies to a simple example Excel file.

[Num,Txt,Raw]=xlsread('test.xls');
colors = {'r', 'k', 'g'};  %red, black, green
linetypes = {'--', '-'};   %dashed, solid
figure(1);hold on;
for k=2:4
    plot(Num(4:end,1),Num(4:end,k),[colors{Num(1,k)},linetypes{Num(2,k)}],'linewidth',Num(3,k));
end

25 个评论
显示 23更早的评论隐藏 23更早的评论

Dima 2011-9-16

thanks...yes I did add the data in the 5th column and ran your code with the k=2:5 and it gives off the above error...(??? Index exceeds matrix dimensions. ) I surely need to read much more)) but I woudl be so thankful if you could show me how to add mroe columns to this calculations...that is the workbook I am using now:

1 1 2 1 1 COLOUR

1 2 1 2 3 TYPE

1 1 2 1 5 THICKNESS

1 5.678629242 7.703233636 4.445358125 5.954986076 0

2 5.660599394 7.685203788 4.40766875 5.955991899 0

3 5.642569545 7.667173939 4.369979375 5.956997722 0

4 5.624539697 7.649144091 4.33229 5.958003544 0

5 5.606509848 7.631114242 4.294600625 5.959009367 0

6 5.58848 7.613084394 4.25691125 5.96001519 0

7 5.570450152 7.595054545 4.219221875 5.961021013 0

8 5.552420303 7.577024697 4.1815325 5.962026835 0

9 5.534390455 7.558994848 4.143843125 5.963032658 0

10 5.516360606 7.540965 4.10615375 5.964038481

11 5.498330758 7.522935152 4.068464375 5.965044304

12 5.480300909 7.504905303 4.030775 5.966050127

13 5.462271061 7.486875455 3.993085625 5.967055949

14 5.444241212 7.468845606 3.95539625 5.968061772

15 5.426211364 7.450815758 3.917706875 5.969067595

16 5.408181515 7.432785909 3.8800175 5.970073418

Fangjun Jiang 2011-9-17

The function is text().

Dima 2011-9-18

thanks....it is inserted in the list of the arguments of the plot function right?

请先登录，再进行评论。

Dima 2011-9-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/15871-plot-multiple-time-series-based-on-individual-condition#answer_22919

Fangjun Jiang! Maybe you can also help me with one more questions about the code you provided before....I wonder if it is possibel to specify the colors not in the default format (e.g. 'r') but in the RGB format ( [1 0 0])? I ask this because I need different shades few red and blue...) Thanks!) D