Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.

Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same color by default. Another way to display the chart is to change the color of the ...