Forum Discussion
Excel rename histogramm data
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 ?
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
Regards,
karchavez
- Thank you for your Help, this works fine for me
Br Marcel
