Text Box

  • Thread starter Thread starter Bern Muller
  • Start date Start date
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.
 
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.
Click to expand...

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
 
Back
Top