Resize Chart to fit picture fill Excel 2007
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? |
Resize Chart to fit picture fill Excel 2007
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? |
All times are GMT +1. The time now is 11:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com