Excel rename histogramm data

Copper Contributor

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

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

Thank you for your Help, this works fine for me

Br Marcel