Hide zero values in chart labels- Excel charts WITHOUT zeros in labels
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
Excel trick to only show chart labels that have a number (no zeros where there is a blank or else a zero) WITHOUT having to manually delete the relevant labels each time.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Stop zeros from showing in chart labels
00:32 Trick to hiding the zeros from chart labels (only non zeros will appear as a label)
00:50 Change the number format of the labels
01:00 Understanding how to change the format to make zero numbers disappear
01:35 Each series in the chart needs to be fixed to make all zero labels disappear
