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.

 

[RickXL]

Hi,

Do you mean one of these?

 

[davidhall]

Yes

 

[davidhall]

Just an fyi ...I've also asked this same question in another forum to see if others are able to assist. I'll update both forums once resolved.

Creating a Taylor Diagram in Excel | Chandoo.org Excel Forums - Become Awesome in Excel

 

[RickXL]

The picture in my post was created by me in Excel.

It is currently only what you see. It will need some refining to make it usable by a user. I am not sure whether users would prefer to enter commands into the VB Editor or whether they would be happier to fill in rows in a worksheet. If they would prefer a customized userform then that might be a leter development.

I just wanted to be sure that I was working on exactly the right diagram.

How would you like to enter the data into the chart?
How much flexibility do you need for things like scaling, number of arcs and number of rays etc?

If someone discovers a pre-existing one then by all means use that.

Regards,

 

[davidhall]

Rick,

That's great to hear. Thanks for your help with this.

In terms of entering commands, it would best to see things laid on a worksheet so all of the logic in the formulas can easily be traced. It would be great if there was some flexibility and ability to toggle the number or arcs, rays, etc.

 

[RickXL]

Hi,

Assume I know nothing about these charts and you will be quite close to the truth.

I know they show 3 variables but because they are related you only need two degrees of freedom on the chart. So, presumably, you only supply two values to display a point? If so, which two values are supplied, please?

 

[RickXL]

OK, I am going for Standard Deviation and Correlation.

See the current version at the link: https://dl.dropboxusercontent.com/s/jh0tbtyss8w5hd3/TaylorChart preview.xlsm?dl=0

This web page:

Excel 2013
	L	M	N	O	P	Q	R	S	T
1	Chart Title	New Taylor Diagram
2	Axis Title	Standard Deviations (mm/day)
3	Rays	0.6	0.9
4	Arc1	0.6	1	1.4
5	Arc2	0.2	0.4	0.6	0.8
6	Std Max	1.5
7	StdRef	1
8	Labels	A	B	C	D	E	F	G	H
9	StdDev	0.5	0.6	0.8	0.7	0.95	0.55	0.64	0.5
10	Correlation	0.8	0.9	0.65	0.74	0.91	0.98	0.85	0.35
Sheet1

Produced this chart:

 

[davidhall]

Hi Rick,

Hope you had a good July 4th weekend.

Do I need to run any macros in a certain sequence to produce a new chart? I'm trying to see how the values on the worksheet tie to the data points in the chart.

 

[RickXL]

Hi,

The data table (or form) needs to start in L1.
After that you just need to run the ProcessForm macro.


I went in to File--> Options--> Customize Ribbon

Then, Choose commands from: Macros
Then added ProcessForm into a new group.

After that you can just click on an icon on the ribbon to create a new chart.

I don't know how much of that survived Dropbox but there may be a cloud icon already there but you may need to re-assign the macro.

However, that is personal choice - you can run it how you like.


I feel I have to ask: Could your place of work be said to be associated with a large rock?

Other points: It works with the ActiveSheet. So you can add as many sheets as you like and, as long as the data is in the same format as Sheet1, ProcessForm will produce a chart on that sheet.

Oh, about 4th July - my side lost