A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Link excel 2007 chart formatting



 
 
Thread Tools Display Modes
  #1  
Old August 13th, 2008, 01:34 PM posted to microsoft.public.excel.charting,microsoft.public.excel.links
NabilShuh
external usenet poster
 
Posts: 8
Default Link excel 2007 chart formatting

Is there any way to link the chart appearance as well as the values when I do
a copy and paste of a chart in excel from one workbook to another? Currently
the values change automatically but if I change the chart style in the source
chart the destination charts don't get this.

The other alternative is to link the chart through OLE but excel does not
seem to allow me to link it under paste special (it is greyed out) unlike the
other office apps (word, powerpoint).

Thank in advance for your help
  #2  
Old August 13th, 2008, 06:03 PM posted to microsoft.public.excel.charting,microsoft.public.excel.links
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Link excel 2007 chart formatting

The formatting of objects in Excel are governed by the settings of the
parent workbook. If your two workbooks have different settings, you will get
different appearances.

You could copy the chart as a picture, and the formatting will be retained,
but it will no longer be linked. Or you could use the Camera Tool to copy
the original chart, and put the copy into the second workbook. The result is
a live linked picture of the original chart. You actually have to take a
picture of the cells underlying the chart. Sometimes Camera objects can
consume significant resources.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"NabilShuh" wrote in message
...
Is there any way to link the chart appearance as well as the values when I
do
a copy and paste of a chart in excel from one workbook to another?
Currently
the values change automatically but if I change the chart style in the
source
chart the destination charts don't get this.

The other alternative is to link the chart through OLE but excel does not
seem to allow me to link it under paste special (it is greyed out) unlike
the
other office apps (word, powerpoint).

Thank in advance for your help



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.