Home

To rotate the X axis values in a histogram

%3CLINGO-SUB%20id%3D%22lingo-sub-679876%22%20slang%3D%22en-US%22%3ETo%20rotate%20the%20X%20axis%20values%20in%20a%20histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20everyone%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20a%20histogram%20and%20all%20I'm%20trying%20to%20do%20is%20to%20rotate%20its%20horizontal%20axis%20values%20so%20that%20they%20can%20either%20show%20vertically%20or%20%22slanted%22%2C%20I%20understand%20this%20would%20normally%20be%20done%20via%20the%20%22Textbox%22%20in%20%22Text%20Options%22%20but%20this%20appears%20to%20be%20greyed%20out.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20also%20couldn't%20find%20related%20videos%20on%20Youtube.%20Can%20someone%20please%20help%3F%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%3CBR%20%2F%3EI%20am%20attaching%20a%20spreadsheet%20below.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%20for%20your%20time!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680143%22%20slang%3D%22en-US%22%3ERe%3A%20To%20rotate%20the%20X%20axis%20values%20in%20a%20histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680143%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323852%22%20target%3D%22_blank%22%3E%40K47qqq%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20very%20helpful%20but%20I%20agree%20with%20your%20conclusions.%26nbsp%3B%20I%20could%20produce%20a%20better%20histogram%20using%20the%20FREQUENCY%20function%20and%20a%20column%20chart!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20thing%20that%20might%20help%20though%2C%20is%20to%20further%20modify%20your%20number%20format.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20that%3C%2FP%3E%3CP%3E%3CSTRONG%3E%22%24B%22%23%2C%23%230.0%2C%2C%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eat%20least%20produced%20something%20viewable%2C%20%3CI%3Ee.g.%26nbsp%3B%3C%2FI%3E%5B%24B1.1%2C%20%24B3.1%5D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680258%22%20slang%3D%22en-US%22%3ERe%3A%20To%20rotate%20the%20X%20axis%20values%20in%20a%20histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680258%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Peter%3C%2FP%3E%3C%2FLINGO-BODY%3E
K47qqq
New Contributor

Hi everyone,

I have a histogram and all I'm trying to do is to rotate its horizontal axis values so that they can either show vertically or "slanted", I understand this would normally be done via the "Textbox" in "Text Options" but this appears to be greyed out. 

I also couldn't find related videos on Youtube. Can someone please help? 

I am attaching a spreadsheet below.

 

Thank you for your time!

2 Replies

@K47qqq 

Not very helpful but I agree with your conclusions.  I could produce a better histogram using the FREQUENCY function and a column chart!

 

One thing that might help though, is to further modify your number format. 

I found that

"$B"#,##0.0,,,

at least produced something viewable, e.g. [$B1.1, $B3.1]

Thank you Peter

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies