Chart titles in Excel

[jonew]

Hi,

I am trying to create a chart title in Excel that is a mixture of text and links to a cell in the worksheet.
For example, I want my title to be: Utilisation of Machine X where X is the value of the worksheet cell.
How do I code this?

Any help is much appreciated.

Regards,
J

 

[GlennUK]

You can either have fixed text or a link to a cell, but not a formula combining both.

The easy way round this is to do your concatenation in another cell, and simply link this to the Chart Title.


Cheers, Glenn.

 

[combo]

You can only link cell contents to whole title, so to create dynamic title rather create full title in separate cell (for instance in cell A1 of Sheet1: ="Utilisation of Machine "&A1). Next add any title to the chart, select it and when selected write reference in the formula bar: =Sheet1!A1.

combo

 

[jonew]

Thanks.

Is it possible to have 2 links to worksheet cells in the title? I keep getting an error when I try.

For example I want my title to say "Utilisation of Machine X on July 10th" - where X and July 10th are worksheet cells.

Regards,
Joanne

 

[xlbo]

You're gonna have to go with combo's idea - ie
in a new cell have
="Utilisation of Machine " & cellRef1 & " on " & cellRef2
then ref THAT cell for your title

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[jonew]

Thank you. It's working now!

 

[jonew]

Actually, it's not working quite the way I want.

I combine both cells ="Utilisation of Machine " & cellRef1 & " on " & cellRef2
then ref THAT cell for your title - as suggested.

However cellRef2 is a date. The title ignores the date format and gives me back the date number.
i.e. My title looks like. "Utilisation of Machine X on 37822" when it should read Utilisation of Machine X on 21/07/03.

Any ideas?

 

[combo]

So, convert cellref2 to string:
="Utilisation of Machine "&cellRef1&" on "&TEXT(cellRef2,"dd/mm/yyyy&quot

combo