•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Combining two Format Codes: hiding values AND displaying negative as positive
Hello! I'm making a column chart in Excel. It has both negative and positive values, from -20 to 20. I would like two things in my axis. I know how to do them separately, but is there any way to combine them?
Firstly I want the negative values to display as positive but still BE negative. This is how i managed it:
Axis options -> number -> format code: #,##0;#,##0 (Works well, only problem is it now shows all numbers with a decimal)
Secondly I want to hide the numbers 20 and -20. This is how i managed it:
Axis options -> number -> format code: [=20]"";[=-20]"";Standard
How would I combine these two? Thanks!!
Edit: I am using Microsoft 365, version 2603
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#no-code spreadsheet solutions
#Excel alternatives
#rows.com
#financial modeling with spreadsheets