Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

Is this possible? I don't think its directly supported and we might have to add the text as "series" and turn on data labels.

share|improve this question

Nevermind, it was really simple.

Just create a textbox on the chart and then in the formula bar reference the cell you want.

I problem was I was trying to type the formula into the textbox!

share|improve this answer

Do you mean this:

Sheet 1 - A1 cell: 10  
Sheet 2 - A1 cell: =Sheet1!A1
share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.