How to Name Ranges in Excel
Select the range you want to name, including the row or column labels. Select Formulas > Create from Selection. In the Create Names from Selection dialog box, select the location of the labels by selecting Top row, Left column, Bottom row, or Right column. Select OK. You can make formulas easier to understand by using names. You can define a name for cell range, function, constant, or table. Adopt the practice of using names to easily update, audit, and manage. In the NAME Box, type a name and press Enter. To use the name in a formula, type the first letter of the name and select it from the list.
Naming Columns in Excel Charts
How do I name columns in Excel chart?
Right-click a bar, choose ‘Add Data Labels’, then ‘Format Data Labels’, and choose Alignment. You can change the text of each data label.
Creating a Column Title
How do you make a column title?
Click the column’s letter, click the "Formulas" tab, then "Define Name", and enter the new name in the Name text box.