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
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"polydatascatter" wrote in
message ...
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?