Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Thankfully, you can show data in several ways. In one example, we could click on one of the points to activate it, and then right-click on it to access the Add Data Label option.

While they might look like an advanced feature, it's very easy to add data bars to a spreadsheet in Excel with just a few clicks.

Scatter charts use two columns of data for each point. By default, Excel will use the first column for the X coordinate and the second for the Y coordinate. To add additional data for the Y axis ...