numbers in a chart

  • Thread starter Thread starter johann
  • Start date Start date
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
 
Put a textbox from the drawing toolbar on the chart. select the textbox.
In the formula bar put in the formula

=Sheet1!A1
 
this wouldn't work since the values change depending on
the chart that is selected. Any other suggestions?
 
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.
 
You must log in or register to reply here.

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

Similar Threads

How do you chart data from multiple sheets within a workbook? 3
Automatically selecting active chart 4
Multiple selected charts 1
Create several charts in one go using VBA 4
I need to give index number to charts 3
Conflict 8
Paste Excel Chart into Existing Powerpoint Chart 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16

Back
Top