Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
John Mansfield
 
Posts: n/a
Default Pie Charts Resize Automatically - How To Avoid?

Matt,

This is probably not the answer you're looking for but it's a workaround . .
.. I've sometimes had to use a third party screen capturing software like
Hypersnap or SnagIt to first capture an image of the charts. Then, after
saving that image as a .gif file, I'll PDF the .gif image. I too can't
explain the strange PDF behavior.

--
Regards,
John Mansfield
http://www.pdbook.com


"Matt Kruse" wrote:

I have two pie charts side-by-side that need to be exactly equal in
size. After populating the data, I have a macro which accomplishes
this.

On the screen, they are the same size.

However, when printed or converted to PDF, sometimes the pie chart
sizes change. It's fairly unpredictable, from what I have seen,
depending on the data.

How can I force two pie charts to be exactly the same size no matter
what data they are showing or whether it's printed or converted to PDF?

I am currently testing with Excel 2002 on XP Pro.

Thanks!

--
Matt Kruse
http://www.JavascriptToolbox.com


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
linkingof charts in worksheets to cells steve Excel Discussion (Misc queries) 0 May 6th 05 01:44 AM
Urgent help! how to automatically resize all the charts? crossingmind Excel Worksheet Functions 2 April 28th 05 04:56 PM
XL 03:Side by side windows: as you resize one workbook, the other. White bellied Excel Discussion (Misc queries) 1 April 25th 05 08:52 PM
Can't create dynamic charts Brian Sells Charts and Charting in Excel 7 March 22nd 05 04:23 AM
initial size of new charts bob m Charts and Charting in Excel 1 January 22nd 05 02:19 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"