If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|