export chart - size problem

A

Art Parra

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,
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save chart as 800x600 GIf 3
Export chart to GIF no longer works after installing Excel 2007b2 15
Export to image ... way to get just cells without chart background? 3
export chart method error - excel2003 4
Chart export - high resolution, no gif or jpeg 3
How can I change size of the picture without changing chartobject? 6
disabling chart export progress bar 1
Export Pie Graph Chart as Image 7

Top