Linking concatenated text into a graph. ..?

[axilla2]

trying to automate some repetitive tasks.

I have data driving charts, I also need to display some text in Textbox within the chart. This text changes so i'd like to link it a cell that changes with some fansy-doo concatting.

i'll try making a macro to cut/paste the text into the chart, but if you know of an easier way to link text into a chart (or a textbox for that matter), please let me know.

 

[xlbo]

put the concatenated text in a cell - say A1
so in A1, you will have summat like
=B1 & " - " & C1

then, click in the title and then click in the formula bar. Enter an equals sign (=) and then click on A1 et voila

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[dan1967]

Click on your graph and in the formula bar type "=" and the cell reference you want included then press Enter:

=Sheet1!$A$1

Dan.