Is there a way to instruct Excel to resize a chart to fit a picture when you
are using the picture as a fill for the chart area? For example, you have a
square chart area and you fill the chart area with a jpg file of a dollar
bill. By default the picture resizes to fit the chart area, in this case
distorting the dollar bill. You can manually resize the chart area to fit
the picture by dragging the borders, but can this be done automatically?

You need to tell Excel what size to use. Perhaps you can write code that
determines the size of the picture, then rescales the chart automatically.

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


"Ted M H" wrote in message
...
Is there a way to instruct Excel to resize a chart to fit a picture when
you
are using the picture as a fill for the chart area? For example, you have
a
square chart area and you fill the chart area with a jpg file of a dollar
bill. By default the picture resizes to fit the chart area, in this case
distorting the dollar bill. You can manually resize the chart area to fit
the picture by dragging the borders, but can this be done automatically?