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

The Box and Whisker Chart shows the distribution of data into quartiles, highlighting the mean and outliers. Follow the steps below to create a Box and Whisker Chart in Microsoft Excel: Create a ...

To hide a chart's data series, click the "Chart Filters" button and then deselect the check boxes in the Series or Categories section on the Values tab. Click "Apply." Save this worksheet.

Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

The Sparkline feature, introduced in Excel 2013, lets you select data from rows or columns of cells and display line, column or handy win/loss charts. Jim Desmond It’s easy!

You need to manually resize the comment box to see the rest of the comment data. While this is okay for one or two comments, resizing each comment box when there are a lot of comments in an Excel ...

By dynamic list, I really mean a dynamic range that contains a list of data items. Let’s take a look at a quick example. The following userform contains one combo box, with an identifying label.