Home » Questions » Computers [ Ask a new question ]

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: 64
Total answers/comments: 1
Guest [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"