numbers in a chart

J

johann

hello,

I'd like to display the value of Sheet!A1 inside a chart
object in Sheet2. How would this be possible?

Thanks for the help.

--Johann
 
T

Tom Ogilvy

Put a textbox from the drawing toolbar on the chart. select the textbox.
In the formula bar put in the formula

=Sheet1!A1
 
J

johann

this wouldn't work since the values change depending on
the chart that is selected. Any other suggestions?
 
T

Tom Ogilvy

Not based on you illogical comment.

If you want to see sheet1!A1 in a chart, then it would seem that chart is
the one selected.
 
Top