PC Review


Reply
Thread Tools Rate Thread

Changing Chart Size with Excel 2007

 
 
=?Utf-8?B?Q29vcCBSZXNlYXJjaA==?=
Guest
Posts: n/a
 
      20th Jun 2007
I am trying to use some VBA to print my charts to PDF and am having a hard
time. For now I’ve just selected the areas that the charts are in and used
the Selection.ExportAsFixedFileFormat Function I was wondering if you knew of
a way to print the chart to PDF by selecting only the chart? When I do this
it prints out the chart on an entire page rather than relative to its actual
size

Also, do you know of any ways to programmatically change the sizes of the
charts in a workbook. This was all possible in Excel 2003 using things like;

ActiveSheet.ChartObjects(“Chart 1”).Activate
and
With ActiveChart.PageSetup(margin1, margin2)

I don't necessarily need to use ChartObject to do this if there is another
way. All I am looking for is to be able to print charts to PDF and resize
them to my own specifications. Anyway of doing this will be greatly
appreciated

Thank you so much for anything you can do to help.

-Matt-
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Define the size of an Excel Chart (Office 2007)?? Vit Microsoft Excel Charting 0 15th Oct 2009 09:13 AM
2007 Excel/Powerpoint - Chart size when linking Kathy at M/A/R/C Microsoft Powerpoint 6 10th Mar 2009 10:12 PM
2007 Excel/Powerpoint - Chart size when linking Kathy at M/A/R/C Microsoft Excel Misc 0 9th Mar 2009 06:31 PM
How do I size a chart with the window in excel 2007 WHfan Microsoft Excel Charting 3 19th Jan 2009 12:14 AM
Re: Changing Excel Chart Size keepitcool Microsoft Excel Programming 2 15th Aug 2003 03:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:14 PM.