How to create label on chart containing contents from a cell on another sheet?

How to create label on chart containing contents from a cell on another sheet? Simple problem. I have a chart in Excel and some text data on a sheet. I want to create labels on the chart that reference text on another sheet. I want to be able to update the text and have the labels on the chart be in sync.
Asked by: Guest \| Views: 282

Total answers/comments: 1

Comments display order:

bert [Entry]

"You can do the same with the chart title as well - select it, click in the formula bar, add a formula as usual
This might be just a link to a cell eg =A1, or w hole complicate thing, or some concatenated text like =""Sales figures for ""&A1&"" region, ""&B1&"" to ""&C1"