Excel rename histogramm data

%3CLINGO-SUB%20id%3D%22lingo-sub-1421566%22%20slang%3D%22de-DE%22%3EExcel%20rename%20histogram%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1421566%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%2C%20%3CBR%20%2F%3E%20I%20now%20have%20data%20from%20a%20survey%20with%20gender%20options%20man(1)%20or%20female%20(2).%20I%20now%20want%20to%20show%20that%20amount%20in%20a%20histogram.%20%3CBR%20%2F%3E%20Which%20is%20working%2C%20but%20is%20it%20possible%20to%20write%20male%20and%20female%20instead%20of%20%5B1%201%2C64%5D%20%5B1%2C64%202%2C28%5D%20I%20already%20searched%20the%20web%20put%20could%20not%20find%20an%20answer.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Can%20you%20please%20help%20me%2C%20if%20this%20is%20possible%20%3F%20%3CBR%20%2F%3E%20Is%20there%20another%20way%20to%20show%20this%20kind%20of%20information%20%3F%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%22Marcel1234655_0-1590602651921.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%2F194831i42140E6DF7B2FDC9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Marcel1234655_0-1590602651921.png%22%20alt%3D%22Marcel1234655_0-1590602651921.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1421566%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1422319%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20rename%20histogramm%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422319%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681363%22%20target%3D%22_blank%22%3E%40Marcel1234655%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EI%20suggest%20you%20to%20add%20a%20column%20with%20the%20Gender%20Name%20and%20display%20the%20histogram%20By%20Category%2C%20I've%20attached%20the%20solution%20file%2C%20this%20will%20be%20the%20result%3A%3C%2FP%3E%3CP%3EPlease%20accept%20as%20a%20Best%20response%20if%20this%20works%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ERight%20click%20on%20your%20histogram%26gt%3BFormat%20Data%20Series%20or%20Plot%20Area%26gt%3BHorizontal%20Axis%26gt%3BAxis%20Options%26gt%3BBy%20Category%3C%2FSTRONG%3E%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%22karchavez_1-1590626121341.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%2F194907i5FE225E4FA7A0C09%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22karchavez_1-1590626121341.png%22%20alt%3D%22karchavez_1-1590626121341.png%22%20%2F%3E%3C%2FSPAN%3E%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%22karchavez_0-1590626062559.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%2F194906iEDCC99DF96EE7F2E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22karchavez_0-1590626062559.png%22%20alt%3D%22karchavez_0-1590626062559.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3Ekarchavez%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423038%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20rename%20histogramm%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423038%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20Help%2C%20this%20works%20fine%20for%20me%3CBR%20%2F%3E%3CBR%20%2F%3EBr%20Marcel%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,
I have now data from a survey with gender options man(1) or female (2). I now want to show that amount in a histogramm.
Which is working, but is it possible to write male and female instead of [1 1,64] [1,64 2,28] I already searched the web put could not find an answer.

Can you please help me, if this is possible ?
Is there another way to show this kind of information ?

 

Marcel1234655_0-1590602651921.png

 

2 Replies
Highlighted

Hello @Marcel1234655 ,

I suggest you to add a column with the Gender Name and display the histogram By Category, I've attached the solution file, this will be the result:

Please accept as a Best response if this works for you.

 

Right click on your histogram>Format Data Series or Plot Area>Horizontal Axis>Axis Options>By Category

 

karchavez_1-1590626121341.png

 

karchavez_0-1590626062559.png

Regards,

karchavez

Highlighted
Thank you for your Help, this works fine for me

Br Marcel