Tornado diagram horizontal axis scale.

%3CLINGO-SUB%20id%3D%22lingo-sub-2938480%22%20slang%3D%22en-US%22%3ETornado%20diagram%20horizontal%20axis%20scale.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938480%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20need%20your%20assistance%20in%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20tornado%20diagram%20and%20I%20want%20the%20bars%20to%20be%20centered%20on%20a%20value%20other%20than%20zero%2C%20so%20the%20butterfly%20shape%20starts%20from%20that%20value%20rather%20than%20z%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2938480%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938507%22%20slang%3D%22en-US%22%3ERe%3A%20Tornado%20diagram%20horizontal%20axis%20scale.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938507%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780014%22%20target%3D%22_blank%22%3E%40SARAH11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20I%20could%20do%20now%2C%20however%2C%20this%20is%20not%20what%20I%20want%2C%20as%20you%20can%20see%20the%20bars%20are%20centered%20around%20zero.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22step2-insert-a-bar-chart-to-create-tornado-chart.png%22%20style%3D%22width%3A%20884px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325154i544F274C56DDFD1D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22step2-insert-a-bar-chart-to-create-tornado-chart.png%22%20alt%3D%22step2-insert-a-bar-chart-to-create-tornado-chart.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20make%20a%20diagram%20like%20the%20image%20below%20where%20the%20bars%20are%20centered%20on%206.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%2217.png%22%20style%3D%22width%3A%20574px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325157iC2708BE5D541BDB7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%2217.png%22%20alt%3D%2217.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938685%22%20slang%3D%22en-US%22%3ERe%3A%20Tornado%20diagram%20horizontal%20axis%20scale.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938685%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780014%22%20target%3D%22_blank%22%3E%40SARAH11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20done%20format%20axis%20%26gt%3B%26gt%3B%20axis%20options%20%26gt%3B%26gt%3B%20vertical%20axis%20crosses%20%26gt%3B%26gt%3B%20axis%20value%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20I%20have%20changed%20in%20to%2031%2C733.10%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20pic%20is%20before%20the%20value%20change%20(%20when%20it%20was%200)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SARAH11_0-1636373865402.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325183i786B2C35E0BE9FB6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SARAH11_0-1636373865402.png%22%20alt%3D%22SARAH11_0-1636373865402.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eand%20this%20picture%20is%20after%20I%20changed%20the%20value%20to%2031%2C733.10%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SARAH11_1-1636373921001.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325185i96D10DFAB5B9E1ED%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SARAH11_1-1636373921001.png%22%20alt%3D%22SARAH11_1-1636373921001.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eas%20you%20can%20see%2C%20the%20bars%20are%20still%20in%20their%20place%2C%26nbsp%3B%20only%20the%20middle%20line%20changed!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello, 

 

I really need your assistance in this. 

 

I am creating a tornado diagram and I want the bars to be centered on a value other than zero, so the butterfly shape starts from that value rather than 0.

 

2 Replies

@SARAH11 

This is what I could do now, however, this is not what I want, as you can see the bars are centered around zero. 

step2-insert-a-bar-chart-to-create-tornado-chart.png

 

I want to make a diagram like the image below where the bars are centered on 6. 

17.png

 

@SARAH11 

 

I have done format axis >> axis options >> vertical axis crosses >> axis value 

and I have changed it to 31,733.10 

The following pic is before the value change ( when it was 0)

 

SARAH11_0-1636373865402.png

and this picture is after I changed the value to 31,733.10 

SARAH11_1-1636373921001.png

as you can see, the bars are still in their place,  only the middle line changed!