text boxes pin and charts

Mikexcel

New Member
Joined
Sep 15, 2002
Messages
5
Hello All:

Is there any way possible to pin a text box to a chart, so that when you move the chart itself, the textboxes will follow. I need to have the textboxes on the chart because the info within them are a combination of dynamic and static.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

jfuoti

New Member
Joined
Mar 26, 2002
Messages
48
Make sure you are in the chart. Go into the formula line (or hit F2) and start typing the text you want or just the adress for the cell you want to link and hit enter. This will create a text box within the chart that will move with it. The great thing is that it can be dynamic, so if you link it to a cell and change the cell, the text on the chart will be updated. HTH.
 

Mikexcel

New Member
Joined
Sep 15, 2002
Messages
5
thanks - it is always the 1st place that you shuold have looked, i guess.
 

Forum statistics

Threads
1,144,510
Messages
5,724,784
Members
422,579
Latest member
Lekha mohanty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top