StupidExcelQuestionFilter: Adding x and y axis labels

February 15, 2008 1:59 PM

How do I add x and y axis labels to a chart in Excel 2008 for Macs?

I've been trying to do this for about an hour and am just about ready to tear my hair out. The whole thing should be ridiculously simple but I'm just not seeing it. So I have two columns of data which I want to plot against each other. So I did that. Now I want to add an x axis label and a y axis label (e.g. 'Voltage' and 'Time'). I just can't figure out how to do it. No matter where I click on the chart the box for adding these labels doesn't open up. There doesn't seem to be any way to do this from the menus on top either. I'm sure I'm just missing something obvious, so would really appreciate it if you could help me out.

posted by peacheater to computers & internet (2 answers total)

Click on the chart to select it. Then go to the Formatting Palette > Chart Options > Titles. (If it's not visible, choose View > Formatting Palette.) There is a drop-down menu. From the drop down menu, choose either Horizontal or Vertical, and enter your text in the area immediately below. Not intuitive, but easy once you see it.
posted by mosk at 2:57 PM on February 15, 2008

Thanks a lot! I feel stupid now :)
posted by peacheater at 4:31 PM on February 15, 2008