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 » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copying Excel 2007 Charts as picture (as seen on screen)



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 08:00 PM posted to microsoft.public.excel.charting
Ken
external usenet poster
 
Posts: 954
Default Copying Excel 2007 Charts as picture (as seen on screen)

The copy as picture (as seen on screen) function in excel 2007 seems to work
for charts if doing it directly from Excel to other application. But if you
try to code it in VBA, more often than not a chart or two disappears and does
not copy to the designated application (e.g. Word). This is annoying. It
works when copying as picture directly from Excel to Word. But once you try
to code it, it is very sporadic. More often than not, eliminated a chart when
pasting?????? Is there something additional that needs to be used in the code?
Usually if I highlight the chart I want to copy via code, it will end up
working. But if I open the file and try to run the macro/code directly, then
all kinds of charts disappear???
I can't seem to find any other problems of this nature out on the web?? It
worked fine for me in 2003, but 2007, the chart object is hit or miss when
copying as picture.
Thank you
Ken
  #2  
Old April 17th, 2010, 07:28 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Copying Excel 2007 Charts as picture (as seen on screen)

I haven't seen a code-related problem with the code approach. My code is
shown in http://peltiertech.com/Excel/XL_PPT.html

The problem for me is that I don't like the appearance of the chart in
2007 when pasted as a picture. They've uglified it, over anti-aliased
it, and grouped together elements that you used to be able to ungroup.
For example, gridlines are no longer separate line, but now a
rectangular shape with lines across it. Same with tick marks.

There are so many ways that Excel 2007 charting has been such a
disappointment.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 4/16/2010 3:00 PM, Ken wrote:
The copy as picture (as seen on screen) function in excel 2007 seems to work
for charts if doing it directly from Excel to other application. But if you
try to code it in VBA, more often than not a chart or two disappears and does
not copy to the designated application (e.g. Word). This is annoying. It
works when copying as picture directly from Excel to Word. But once you try
to code it, it is very sporadic. More often than not, eliminated a chart when
pasting?????? Is there something additional that needs to be used in the code?
Usually if I highlight the chart I want to copy via code, it will end up
working. But if I open the file and try to run the macro/code directly, then
all kinds of charts disappear???
I can't seem to find any other problems of this nature out on the web?? It
worked fine for me in 2003, but 2007, the chart object is hit or miss when
copying as picture.
Thank you
Ken

 




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 05:30 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.