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 ...
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
Br Marcel