Copy Paste text box from one chart to another

Chuck101 · #1 09-04-2008, 04:25 PM

Hello - I have 10+/- charts and I use text boxes to display the same information on each chart e.g. Name, Department, Update date, Size, Color etc.. Each text box is linked back to a cell on a "user input" sheet. Depending on what I want to display I might need to add a text box to all of the charts. In Excel 03 I could create a text box on one chart then copy / paste from one chart to another and it would keep the cell referece. In Excel 07 copy / paste seems to be a copy / paste-special-values - it does not keep the cell reference. Is there an options setting I'm missing? Copy / paste works fine on normal sheets - the issue only seems to be with charts.

**Andy Pope** · #2 09-05-2008, 08:37 AM

Looks like a bug.
Although copying the chart with a linked textbox appears to keep the link.

You could use code to re-apply the link

Chuck101 · #3 09-09-2008, 02:33 PM

I think you're right, must be a bug. Let Bill know next time you see him

.

Thanks

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy paste Text Box	jeff.p	Excel Programming	4	09-14-2007 01:14 AM
copy and paste problem	tweacle	Excel Programming	3	09-07-2007 02:07 PM
Macro to copy and paste information from other applications to Excel	mvatoi	Excel Programming	1	08-01-2007 04:20 AM
Copy from a column of one file and paste in another aftr using formula in the first 1	kaanthsap	Excel General	1	07-01-2007 07:21 PM
Text Boxes on Chart	Freezerburn	Excel Miscellaneous	1	03-27-2007 06:29 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)