Quick LinksHide Cell ValuesReplace Zeros With a DashTurn Values to Text Based on a ConditionColor Numbers Based on Their ...

Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to the format you prefer.

Borders help separate components in a document or on a chart. If you'd like to change your legend's border color to make it more noticeable, click the Format Legend's "Border" button and then ...

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that. Image: PixieMe/Shutterstock ...

See the screenshot below. To color-code specific text, select the cells that contain (or will contain) the text that you want color-coded. In the example above, I have selected cells B2:B27. At this ...

You can change the default color of chart, graph, treemap, etc. in Word, Excel, and PowerPoint with the helpof these simple steps.

Your results may vary depending on Excel’s default settings and theme colors. Now that you know the example data, let’s review a few methods for suppressing the zero values in our example charts.