PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting export chart - size problem

Reply

export chart - size problem

 
Thread Tools Rate Thread
Old 06-12-2004, 10:47 PM   #1
Art Parra
Guest
 
Posts: n/a
Default export chart - size problem


I'm converting a chart to gif with:

Activechart.export filename:=chartfname, filtername:="GIF"

It used to work fine but now the chart size is incorrect. The charts
looks exactly the same on the spreadsheet. Initially the gifs were 846
by 625, now they are 643 by 625. What controls the size of the
exported image (other than the screen resolution)?

thanks,

--
Art


  Reply With Quote
Old 07-12-2004, 01:58 AM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: export chart - size problem

Art -

Embedded charts? Same zoom (in fact, I suggest that you keep it at 100% and adjust
fonts and stuff accordingly)?

Funny that the width is the same....

Are the charts created in code? Are the Excel window and the workbook window both
maximized? Do you have a lot more commandbars showing than before?

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

Art Parra wrote:

> I'm converting a chart to gif with:
>
> Activechart.export filename:=chartfname, filtername:="GIF"
>
> It used to work fine but now the chart size is incorrect. The charts
> looks exactly the same on the spreadsheet. Initially the gifs were 846
> by 625, now they are 643 by 625. What controls the size of the
> exported image (other than the screen resolution)?
> thanks,
>


  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

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