Dynamic Text in a Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I insert in a chart (not as data, but as text) a cell value, whether
a number or a word? The idea is that as the cell changes in the spreadsheet,
the number or word changes in the chart area. Any help is greatly
appreciated.
 
Click once inside of the chart. Then click once inside of the formula bar.
Type an equal (=) sign into the formula bar. Then click once on the cell
that you want to refer to in the textbox. You see the referenced cell in the
formula bar (ex. =Sheet1!A1). Now hit ENTER. A textbox should appear inside
of the chart with a direct reference to the cell.
 
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

Dynamic Chart Help 3
Dynamic X-Axis in Chart 2
Select Specific Data From Cells For A Chart 4
Copying Excel 2007 chart to Word 2007 - only half of it shows 2
Chart 2
Set chart series endpoint dynamically 0
PowerPoint Embed scroll excel chart and data in powerpoint 0
Bizarre chart behaviour when changing axis cross at points 2

Back
Top