When Microsoft released Office 2013, the company added a new task pane to Excel that can help you apply advanced formatting options to a legend or any other chart element.

In this guide, I'll walk you through the different ways to format your chart, with Excel's main chart-formatting actions written in bold so you can find them more easily.

A legend box in an Excel chart lists the chart's data series. It specifies each series' name and the color of its marker on the chart. When you try to edit a legend using the Format Legend dialog ...

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.