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? |
make column headings automatically appear as axis chart labels
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? |
All times are GMT +1. The time now is 07:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com