![]() |
Resize chart and preserve formatting (Excel 2007)
Hi,
I would like to uniformly scale a chart and preserve its current look. When I currently resize/scale a chart the entire formatting is altered and it no longer looks correct (when I make it small, the only thing visible is the chart title). I read somewhere here that you can copy it as a 'picture' or a 'wmf' file, but I am using Excel 2007 and I dont know how to do that. I would prefer to keep the chart in a vector format. Thanks. |
Resize chart and preserve formatting (Excel 2007)
Sorry, figured it out, start a new copy of excel, right click, paste special
Picture (enhanced metafile) [emf] "aboeing" wrote: Hi, I would like to uniformly scale a chart and preserve its current look. When I currently resize/scale a chart the entire formatting is altered and it no longer looks correct (when I make it small, the only thing visible is the chart title). I read somewhere here that you can copy it as a 'picture' or a 'wmf' file, but I am using Excel 2007 and I dont know how to do that. I would prefer to keep the chart in a vector format. Thanks. |
Resize chart and preserve formatting (Excel 2007)
They have cleverly hidden the Copy As Picture command under Paste in the
Home ribbon tab. Click on the down arrow under Paste, select As Picture, then select Copy As Picture. Select the On Screen and Picture Format options. Click on a cell someplace and paste the picture (Ctrl+V or the Paste button). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "aboeing" wrote in message ... Sorry, figured it out, start a new copy of excel, right click, paste special Picture (enhanced metafile) [emf] "aboeing" wrote: Hi, I would like to uniformly scale a chart and preserve its current look. When I currently resize/scale a chart the entire formatting is altered and it no longer looks correct (when I make it small, the only thing visible is the chart title). I read somewhere here that you can copy it as a 'picture' or a 'wmf' file, but I am using Excel 2007 and I dont know how to do that. I would prefer to keep the chart in a vector format. Thanks. |
Resize chart and preserve formatting (Excel 2007)
Hi Jon,
They have cleverly hidden the Copy As Picture command under Paste in the Home ribbon tab. Not sure if this was meant to be a joke, but in any case you answered my question so thanks! :) Click on the down arrow under Paste, select As Picture, then select Copy As Picture. Select the On Screen and Picture Format options. Click on a cell someplace and paste the picture (Ctrl+V or the Paste button). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "aboeing" wrote in message ... Sorry, figured it out, start a new copy of excel, right click, paste special Picture (enhanced metafile) [emf] "aboeing" wrote: Hi, I would like to uniformly scale a chart and preserve its current look. When I currently resize/scale a chart the entire formatting is altered and it no longer looks correct (when I make it small, the only thing visible is the chart title). I read somewhere here that you can copy it as a 'picture' or a 'wmf' file, but I am using Excel 2007 and I dont know how to do that. I would prefer to keep the chart in a vector format. Thanks. |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com