make column headings automatically appear as axis chart labels

  • Thread starter Thread starter polydatascatter
  • Start date Start date
P

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?
 
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
 
Back
Top