+ Reply to Thread
Results 1 to 5 of 5

Tornado chart (2-sided chart for 2x2 grouping)

  1. #1
    Registered User
    Join Date
    07-08-2020
    Location
    Cambridge, UK
    MS-Off Ver
    Microsoft for Mace v.1638
    Posts
    3

    Tornado chart (2-sided chart for 2x2 grouping)

    Hi everyone,
    I have little experience with charts in Excel and I'm struggling to create a two-sided chart as this:
    Screenshot 2020-07-08 at 20.41.44.png
    CHARACTERISTIC IMPORTANCE ASSOCIATION IMPORTANCE ASSOCIATION
    MALE MALE FEMALE FEMALE
    C1 80.00 61 88.00 50
    C2 80.00 67 70.00 41
    C3 60.00 60 70.00 50
    C4 56.00 45 65.00 21
    C5 71.00 75 60.00 73
    C6 50.00 33 66.00 19
    C7 71.00 80 56.00 80
    C8 44.00 51 53.00 45
    C9 66 . 50 .

    Any help please would be much appreciated.
    Attached Images Attached Images
    Last edited by LinaM17; 07-08-2020 at 04:05 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,601

    Re: Tornado chart (2-sided chart for 2x2 grouping)

    Some simple steps to do a similar graph:
    create bar chart from all data
    click on one of male series
    format to be displayed on secondary axis
    the same with second male series
    format both horizontal axes to be from -100 to 100
    format secondary axis in reversed order (this will move male bars to left side of graph)
    secondary horizontal axis:
    click on it to select. Press Del
    vertical axis:
    axis labels fill white
    axis labels distance from axis = 0
    number format for horizontal axis custom: #,#,0
    Of course you can do further formatting (like decreasing distance between bars to get rid of vertical gaps, etc.)


    The main disadvantage is that 0 for male touches 0 for female (no gap)

    In the file simple (a bit dirty) trick to be done at the last stage of preparartion is also shown to obtain this gap
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Kaper; 07-09-2020 at 04:15 AM.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    07-08-2020
    Location
    Cambridge, UK
    MS-Off Ver
    Microsoft for Mace v.1638
    Posts
    3

    Re: Tornado chart (2-sided chart for 2x2 grouping)

    Dear Kaper,

    Thank you so much for the prompt response. The key point for me was to set male series on the secondary axis. That solved everything. Thank you very much! Much appreciated!

    Best wishes,
    Lina

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,601

    Re: Tornado chart (2-sided chart for 2x2 grouping)

    Glad to hear so, and thanks for marking thread solved.

    It would be lovely if you colud also "add some reputation" to those who helped (me?) by clicking a small star icon in lowerleft corner of our/my post(s). (and confirming in pop-up/dialog window that "you agree").

  5. #5
    Registered User
    Join Date
    07-08-2020
    Location
    Cambridge, UK
    MS-Off Ver
    Microsoft for Mace v.1638
    Posts
    3

    Re: Tornado chart (2-sided chart for 2x2 grouping)

    Done! Apologies for not doing it earlier but I'm new in this forum and I didn't know it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Tornado chart for sensitivity analysis
    By Ziza in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-12-2015, 10:27 AM
  2. [SOLVED] Help with Tornado chart
    By Mario2 in forum Excel General
    Replies: 2
    Last Post: 03-28-2012, 11:59 AM
  3. How Do I Create a fancy Tornado Chart with data labels?
    By nickFe in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2011, 04:54 AM
  4. Tornado Chart
    By Blake 7 in forum Excel General
    Replies: 2
    Last Post: 03-21-2011, 07:38 AM
  5. Tornado/Sensitivity Chart
    By wb4syth in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-17-2011, 12:57 AM
  6. [SOLVED] tornado chart
    By Karol in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-23-2006, 07:40 PM
  7. [SOLVED] Stacked Bar Chart - used for a Tornado Chart
    By sbeard@rti.org in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-05-2006, 07:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1