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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies