Edit titles or data labels in a chart - Microsoft Support
If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
Link a chart title, label, or text box to a worksheet cell
To easily update a chart or axis title, label, or text box that you have added to a chart, you can link it to a worksheet cell. Changes that you make to the data in that worksheet cell will automatically appear in the chart.
Add or remove data labels in a chart - Microsoft Support
Add data labels to a chart. Click the data series or chart. To label one data point, after clicking the series, click that data point. In the upper right corner, next to the chart, click Add Chart Element > Data Labels. To change the location, click the arrow, and choose an option.
Add a label or text box to a worksheet - Microsoft Support
If someone's entering data inaccurately, or you think a coworker may be confused about how to enter data, add a label. A simple name, such as "Phone," lets others know what to put in a cell, and your labels can also provide more complex instructions. You can add labels to forms and ActiveX controls. Add a label (Form control)
Change the format of data labels in a chart - Microsoft Support
You can format the labels to show specific labels elements like, the percentages, series name, or category name. There are a lot of formatting options for data labels. You can use leader lines to connect the labels, change the shape of the label, and resize a data label.
Guidelines for organizing and formatting data on a worksheet
Use a font, alignment, format, pattern, border, or capitalization style for column labels that is different from the format that you assign to the data in the range. Format the cells as text before you type the column labels.
Link a chart title, label, or text box to a worksheet cell
To easily update a chart or axis title, label, or text box that you have added to a chart, you can link it to a worksheet cell. Changes that you make to the data in that worksheet cell will automatically appear in the chart.
Define and use names in formulas - Microsoft Support
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and …
Dynamically display the contents of a cell or range in a graphic …
To display the contents of a worksheet cell in a shape, text box, or chart element, you can link the shape, text box, or chart element to the cell that contains the data that you want to display. Using the Camera command, you can also display the contents of a …
Add or remove titles in a chart - Microsoft Support
To make a chart easier to understand, you can add chart titles and axis titles, to any type of chart in Excel, Outlook, PowerPoint, or Word.
CELL function - Microsoft Support
The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula: =IF(CELL("type",A1)="v",A1*2,0)