Text Box

B

Bern Muller

I have a chart on its own worksheet. I need to have a text box (or something
similar) on that chart that references a cell in another worksheet. That way
a user could enter a "batch number" once and have it appear in several
graphs in that workbook.

Thanks.
 
D

dvt

Bern said:
I have a chart on its own worksheet. I need to have a text box (or
something similar) on that chart that references a cell in another
worksheet. That way a user could enter a "batch number" once and have
it appear in several graphs in that workbook.

Select the chart. In the formula bar (next to the "fx"), type =Sheet1!A1.
Now the data from cell A1 on Sheet1 will appear in a text box on the chart.

Dave
dvt at psu dot edu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top