I might be alone in this, but I hate seeing hyphens in lieu of 0’s in tables and charts. Here’s what it looks like:
To change these dashes to 0’s select either the column or axis and press Ctrl/Command-1 to open formatting options. The formula, if you will follows this structure:
Positive; Negative; Zero; Text
So just look for “-“?? after the second semicolon and change it to a 0. Easy peezy!
You can learn more about custom number formatting from the Microsoft site.
For more beastly data visualization tips, check out out my Annielytics Dashboard Course offerings.