export chart - what controls exported chart width

[Art Parra]

What controls the chart width when I do export.chart? The funny thing
is that this macro that has been running for a couple of years has been
generating a 843 by 623 chart and now all of a sudden it's generating a
625 by 623 chart, basically cropping it.

thanks,

 

[Don Guillett]

It's customary to post your macro here (NOT an attachment,pls)

 

[Jon Peltier]

The chart width of the exported chart's image is the same as that of the chart in Excel.

Is it an embedded chart? Has the size of the open window (or pane, if you use freeze
panes) changed, within which the program creates the chart?

Is it a chart sheet? Have the margins in Page Setup changed?

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