View Single Post
  #1  
Old December 17th, 2009, 11:39 PM posted to microsoft.public.excel.charting
polydatascatter
external usenet poster
 
Posts: 1
Default make column headings automatically appear as axis chart labels

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?