export chart - what controls exported chart width
 

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,

--
Art Parra
Sr. Flight Ops. Research Analyst
Ph: 901-224-5116 Fax:901-224-6473

export chart - what controls exported chart width
 

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

--
Don Guillett
SalesAid Software

"Art Parra" wrote in message
...
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,

--
Art Parra
Sr. Flight Ops. Research Analyst
Ph: 901-224-5116 Fax:901-224-6473

export chart - what controls exported chart width
 

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


Art Parra wrote:

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,