Color can make it easier for people to identify important information, such as legends on an Excel graph. Professional designers learn to use color coding effectively to make websites ...

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 ...

Dropdowns are useful features that simplify data entry and enforce data validations in spreadsheet software. Creating a dropdown list is easy. And you might have done that already in Excel.

You can also create color scales, which code cells based on their value compared to other cells. Data bars are a powerful visual tool you can apply in Excel to help people understand the data you ...