Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .