make column headings automatically appear as axis chart labels

[polydatascatter]

if i highlight a range (say two columns ) of data and i have the first col as
'x' values with the data type as a column heading eg 'length (metres)' and
the 2nd column as say 'weight (kilograms)', can I get Excel to automatically
use these upper cells as axis labels when i insert a chart?

 

[Bernard Liengme]

Not automatically but you can link a chart title (axis or main) to a cell by
selecting the title, typing = in the formula bar and clicking the cell to
generate a reference such as =Sheet1!$A$1
best wishes