Jun 11 2019 11:59 AM
I'm trying to change the X axis values to read: "Not Impaired" and "Impaired" instead of the 1, 2 values
Jun 12 2019 01:57 AM
@Torifox43Could you please draw an imaginary graph for the final result you want?
Jun 12 2019 07:39 AM
@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:
Jun 12 2019 12:41 PM
@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.