Creating Taylor Diagrams in Excel

[davidhall]

I'm trying to create a Taylor Diagram using excel and I'm looking to see if someone knows where I can obtain a template and/or instructions on how to do it.

Any help is much appreciated.

 

[biknpl]

I don't know - you tell me.

Can you post a link to a Taylor Diagram that shows RMSE? If so I will take a look and see what I can do.

Hi Rick
First of all thankyou for reply. pls find the link
"http://www.nssl.noaa.gov/users/brooks/public_html/feda/papers/Taylordiagrams2001.pdf"

 

[RickXL]

I could reply in kind, say yes, then give you a link to a book on VBA?


Alternatively, as there seem to be at least three references to RMS Error in the pdf, you might consider being a bit more helpful.

At a minimum I shall need to know how you propose to enter the information and how it is to be presented.

Thanks,

 

[biknpl]

I could reply in kind, say yes, then give you a link to a book on VBA?


Alternatively, as there seem to be at least three references to RMS Error in the pdf, you might consider being a bit more helpful.

At a minimum I shall need to know how you propose to enter the information and how it is to be presented.

Thanks,

i want to enter three value sd, R and Rmse . and the curve representig the rmse shuould have a label . Is it possible

 

[RickXL]

OK, so you need an extra data input line. I can do that.

Is there an example of the display you require in the pdf, if so, which one is it, please?

 

[biknpl]

Hey RickXL thankyou very much for this taylor diagram macros. But i am facing a problem that when i run the macros the output taylor diagram is highlighted but i didnt get any way to unhighlight it. how to do it.

 

[RickXL]

I am not sure what you mean by "highlighting". Do you mean the chart is "selected"?

Anyway, what is it stopping you from doing? Can you not just select another cell, for instance.

I have to say that when I try with the Add-In version of the macro, nothing ends up being highlighted.

[I have tried to reply to your PM but your Inbox is reported to be full so I can't.]


Regards,

 

[biknpl]

Sorry,ya chart get selected and i also selected other cells but it doesnot change the result the chart is still selected

 

[biknpl]

https://drive.google.com/drive/folders/0B8q1Mdgl8EJgUXNWSGp3bG9SUWc heres the result of after running macros

 

[RickXL]

Yours looks different to mine. I think it is displaying symbols for each point. Is that what you mean?

 

[biknpl]

Yours looks different to mine. I think it is displaying symbols for each point. Is that what you mean?

I dont know whats wrong with mine ,I just edited the arc1,arc2 point and added other levels.