Forum Discussion
Bar graph with non-numeric labels
I'm trying to change the X axis values to read: "Not Impaired" and "Impaired" instead of the 1, 2 values
3 Replies
Torifox43Could you please draw an imaginary graph for the final result you want?
Ayman_Hassan Sure! I basically want the graph I attached above, but with "Impaired" where the "1" is on the x-axis and "Not impaired" where the "2" is on the x-axis. It should look something like this:
Torifox43I am thinking of it but you know, bar chart is based on the idea that some bars are longer than others so this may indicate that this is bigger or better or longer or something like that. In your case there will not be a logical indicator of error in case we reverse the labels you need to display on the x axis "impaired" "not impaired"
You may implement this manually using shapes which you will need to edit manually, or you can use formulas such as IF and VLookup to display cells in different formats to display your desired shapes which may look like this:
This can be implemented and enhanced manually but also it may be returned dynamically to reflect data changes by using conditional formatting and formulas. This will be a complex solution but I will explain it if you need.
