Creating statistical chart #Diagramme moustache #chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1392244%22%20slang%3D%22fr-FR%22%3ECreating%20statistical%20chart%20%23Diagramme%20mustache%20%23chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392244%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20was%20used%20to%20create%20what%20we%20call%20in%20French%20%22Mustache%20Diagram%22%20with%20my%20previous%20Excel%20version.%20I%20m%20now%20using%20Office%20365%20and%20I%20do%20not%20manage%20to%20find%20my%20tools.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20this%20chart%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22StephanieM56_1-1589533128506.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192006i2C6E1675F21F7007%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22StephanieM56_1-1589533128506.png%22%20alt%3D%22StephanieM56_1-1589533128506.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EMay%20someone%20help%20me....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Looks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStephanie%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1392244%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1392348%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20statistical%20chart%20%23Diagramme%20moustache%20%23chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392348%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20don%E2%80%99t%20use%20a%20French%20or%20English%20excel%20so%20don%E2%80%99t%20take%20my%20translations%20literally.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20an%20ordinary%20bar%20chart.%3C%2FP%3E%3CP%3ESelect%20the%20chart%20and%20go%20to%20%E2%80%9CChart%20design%E2%80%9D%20Add%20chart-element%3A%20Chose%20Error%20bar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20some%20(mysterious)%20pre%20determined%20error%20bar.%20But%20If%20you%20want%20to%20control%20the%20numbers%20you%20chose%20%E2%80%9Cmore%20error%20bar%20alternatives%E2%80%9D.%20To%20the%20right%20you%20will%20have%20%E2%80%9Cformat%20error%20bar%E2%80%9D.%20With%20three%20groups.%20Chose%20the%20one%20that%20looks%20like%203-bars.%20At%20the%20bottom%20you%20will%20see%20%E2%80%9Ccustom%E2%80%9D%20and%20a%20button%20%5BSpecify%20values%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(in%20English%20some%20people%20cal%20them%20Dynamite%20bars%20instead%20of%20Moustache.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1392568%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20statistical%20chart%20%23Diagramme%20moustache%20%23chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392568%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3EHi%26nbsp%3B%20StephanieM56%3CBR%20%2F%3EHi.%20I%20just%20re-read%20your%20question%20and%20realised%20I%20answered%20something%20completely%20different.%3CBR%20%2F%3EI%20think%20you%20are%20looking%20for%20a%20Box-plot%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743f6190f0d%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743f6190f0d%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi everyone,

I was used to create what we call in French "Diagramme Moustache" with my previous Excel version. I m now using Office 365 and I do not manage to find my tools.

 

 

I want to create this chart:

StephanieM56_1-1589533128506.png

May someone help me....

 

Thanks in advance.

 

Best Regards

 

Stephanie

 

2 Replies
Highlighted

Hi. I don’t use a French or English excel so don’t take my translations literally.

 

Create an ordinary bar chart.

Select the chart and go to “Chart design” Add chart-element: Chose Error bar.

 

There are some (mysterious) pre determined error bar. But If you want to control the numbers you chose “more error bar alternatives”. To the right you will have “format error bar”. With three groups. Chose the one that looks like 3-bars. At the bottom you will see “custom” and a button [Specify values]

 

(in English some people cal them Dynamite bars instead of Moustache.)

Highlighted

Hi  StephanieM56
Hi. I just re-read your question and realised I answered something completely different.
I think you are looking for a Box-plot
https://support.office.com/en-us/article/create-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743...