Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

Do you mean this:

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

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
add comment

Your Answer

 
discard

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.