Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 pivot chart formatting CCarlisle Excel Discussion (Misc queries) 0 September 4th 06 07:31 PM
Can I preserve chart formatting when the source data is updated? JasenD Charts and Charting in Excel 3 June 19th 06 01:38 PM
Preserve formatting in Pivot Chart Craig Charts and Charting in Excel 1 January 21st 06 02:20 PM
How do I preserve data formatting in a pivot chart? dblack Charts and Charting in Excel 4 January 4th 06 04:26 PM
How do I resize a chart in Excel after the chart has been saved... DianaQ Charts and Charting in Excel 2 March 19th 05 05:27 AM


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"