Adding Chart and Axis Titles to a chart

[ddub25]

Hello

I can't find any options to give my chart a title or axis titles, can anyone help?

Dan

 

[ayazgreat]

What version of excel are you using and what is the actual problem ?

 

[ddub25]

I am using excel 2007 and what to give a chart that I have created, a Title and Axis Labels, but I don't know how to. I can't find any options to do this. I have tried right clicking all areas of the chart but don't find any areas where I get options to add a Title or Axis Labels.

 

[ddub25]

Actually I've just worked out how to do it.

Another related question though - Is it possible to have the Chart Title be referenced from a cell.

Example: Cell C2="Bankroll". I want the Chart Title to be "Bankroll" and I want it to be referenced from cell C2. Is this possible?

 

[ayazgreat]

Yes it is.

 

[ddub25]

ah good - and how do make a Chart Title reference a Cell to give the chart a name?