ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Resize chart and preserve formatting (Excel 2007) (https://www.excelbanter.com/charts-charting-excel/148028-resize-chart-preserve-formatting-excel-2007-a.html)

aboeing

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.


aboeing

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.


Jon Peltier

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.




aboeing

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