Thanks Thanks:  0
Page 1 of 7 123 ... LastLast
Results 1 to 10 of 69

Thread: Creating Taylor Diagrams in Excel

  1. #1
    Board Regular
    Join Date
    Mar 2011
    Posts
    174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Creating Taylor Diagrams in Excel

    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.

  2. #2
    MrExcel MVP RickXL's Avatar
    Join Date
    Sep 2013
    Location
    UK North Midlands
    Posts
    4,313
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    Hi,

    Do you mean one of these?

    RickXL

    Excel 2013 and Windows 10

  3. #3
    Board Regular
    Join Date
    Mar 2011
    Posts
    174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    Yes

  4. #4
    Board Regular
    Join Date
    Mar 2011
    Posts
    174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    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

  5. #5
    MrExcel MVP RickXL's Avatar
    Join Date
    Sep 2013
    Location
    UK North Midlands
    Posts
    4,313
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    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,
    RickXL

    Excel 2013 and Windows 10

  6. #6
    Board Regular
    Join Date
    Mar 2011
    Posts
    174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    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.

  7. #7
    MrExcel MVP RickXL's Avatar
    Join Date
    Sep 2013
    Location
    UK North Midlands
    Posts
    4,313
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    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

    Excel 2013 and Windows 10

  8. #8
    MrExcel MVP RickXL's Avatar
    Join Date
    Sep 2013
    Location
    UK North Midlands
    Posts
    4,313
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    OK, I am going for Standard Deviation and Correlation.

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

    This web page:
    Excel 2013
    LMNOPQRST
    1Chart TitleNew Taylor Diagram
    2Axis TitleStandard Deviations (mm/day)
    3Rays0.60.9
    4Arc10.611.4
    5Arc20.20.40.60.8
    6Std Max1.5
    7StdRef1
    8LabelsABCDEFGH
    9StdDev0.50.60.80.70.950.550.640.5
    10Correlation0.80.90.650.740.910.980.850.35

    Sheet1





    Produced this chart:
    RickXL

    Excel 2013 and Windows 10

  9. #9
    Board Regular
    Join Date
    Mar 2011
    Posts
    174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    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.

  10. #10
    MrExcel MVP RickXL's Avatar
    Join Date
    Sep 2013
    Location
    UK North Midlands
    Posts
    4,313
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Creating Taylor Diagrams in Excel

    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
    Last edited by RickXL; Jul 7th, 2015 at 07:36 PM.
    RickXL

    Excel 2013 and Windows 10

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •