By default, though, Excel's graphs don't include label information such as the exact numbers used to create the graph or the percentages that are represented.

Create Labels From Excel Now, in a new Word document, locate the Mailings tab and select the Start Mail Merge option. From there, click Labels.

Then, use these instructions to create a dynamic label for columns B through E. To create the dynamic range for column A, do the following: Click the Formulas tab.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.