Resize chart and preserve formatting (Excel 2007)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sorry, figured it out, start a new copy of excel, right click, paste special
Picture (enhanced metafile) [emf]
 
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 said:
Sorry, figured it out, start a new copy of excel, right click, paste
special
Picture (enhanced metafile) [emf]

aboeing said:
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.
Click to expand...
Click to expand...
 
Hi Jon,
They have cleverly hidden the Copy As Picture command under Paste in the
Home ribbon tab.
Click to expand...

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 said:
Sorry, figured it out, start a new copy of excel, right click, paste
special
Picture (enhanced metafile) [emf]

aboeing said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top