Home

Bar graph with non-numeric labels

%3CLINGO-SUB%20id%3D%22lingo-sub-684039%22%20slang%3D%22en-US%22%3EBar%20graph%20with%20non-numeric%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684039%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20change%20the%20X%20axis%20values%20to%20read%3A%20%22Not%20Impaired%22%20and%20%22Impaired%22%20instead%20of%20the%201%2C%202%20values%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20462px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117818i4C96B0E382783711%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-684039%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686494%22%20slang%3D%22en-US%22%3ERe%3A%20Bar%20graph%20with%20non-numeric%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356131%22%20target%3D%22_blank%22%3E%40Torifox43%3C%2FA%3ECould%20you%20please%20draw%20an%20imaginary%20graph%20for%20the%20final%20result%20you%20want%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687298%22%20slang%3D%22en-US%22%3ERe%3A%20Bar%20graph%20with%20non-numeric%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687298%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F31577%22%20target%3D%22_blank%22%3E%40Ayman%20Hassan%3C%2FA%3E%26nbsp%3BSure!%20I%20basically%20want%20the%20graph%20I%20attached%20above%2C%20but%20with%20%22Impaired%22%20where%20the%20%221%22%20is%20on%20the%20x-axis%20and%20%22Not%20impaired%22%20where%20the%20%222%22%20is%20on%20the%20x-axis.%20It%20should%20look%20something%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20960px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117895i1A32750E942AD02D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Untitled.png%22%20title%3D%22Untitled.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-688481%22%20slang%3D%22en-US%22%3ERe%3A%20Bar%20graph%20with%20non-numeric%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-688481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356131%22%20target%3D%22_blank%22%3E%40Torifox43%3C%2FA%3EI%20am%20thinking%20of%20it%20but%20you%20know%2C%20bar%20chart%20is%20based%20on%20the%20idea%20that%20some%20bars%20are%20longer%20than%20others%20so%20this%20may%20indicate%20that%20this%20is%20bigger%20or%20better%20or%20longer%20or%20something%20like%20that.%20In%20your%20case%20there%20will%20not%20be%20a%20logical%20indicator%20of%20error%20in%20case%20we%20reverse%20the%20labels%20you%20need%20to%20display%20on%20the%20x%20axis%20%22impaired%22%20%22not%20impaired%22%3C%2FP%3E%3CP%3EYou%20may%20implement%20this%20manually%20using%20shapes%20which%20you%20will%20need%20to%20edit%20manually%2C%20or%20you%20can%20use%20formulas%20such%20as%20IF%20and%20VLookup%20to%20display%20cells%20in%20different%20formats%20to%20display%20your%20desired%20shapes%20which%20may%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20634px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117951i698D564E0B384A70%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22impaired.jpg%22%20title%3D%22impaired.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20can%20be%20implemented%20and%20enhanced%20manually%20but%20also%20it%20may%20be%20returned%20dynamically%20to%20reflect%20data%20changes%20by%20using%20conditional%20formatting%20and%20formulas.%20This%20will%20be%20a%20complex%20solution%20but%20I%20will%20explain%20it%20if%20you%20need.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Torifox43
Occasional Contributor

I'm trying to change the X axis values to read: "Not Impaired" and "Impaired" instead of the 1, 2 valuesCapture.PNG

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: 

 

 

Untitled.png

@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:

 

impaired.jpg

 

 

 

 

 

 

 

 

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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies