Charts

The UK's most regular instructor-led training courses.
Training information: ms excel training · Excel training courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyMon 8 Feb 2010, 16:12Delegate Lindsay said...

Lindsay has attended:
Excel Intermediate course

Charts

How do yu just cut out the chart ie (pie) without the background in order to paste elsewhere in word/powerpoint

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
Full Schedule: See all 35 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

336 posts

ReplyMon 8 Feb 2010, 16:35Trainer Anthony said...

RE: Charts

Hi Lindsay, thanks for your query. Format out the background of the chart as we did in class, setting the border and Area to none, so that the deselected chart has no background. Copy it, then go into Powerpoint or Word and paste. In 2003, it should paste in the graphic without the background (it's pasting it in as an actual Excel object, i.e. without the background). If that doesn't work trying pasting in as either a Windows metafile or Enhance metafile.

Hope this helps,

Anthony

Tue 16 Feb 2010: Automatically marked as resolved.

· Correct In, Garbage Out
· What's mine is yours: Sharing data in Excel
· From the Classroom to the Corporate World
· Say It With Ribbon
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

Please browse our web site to find out more about
ms excel training and other Microsoft training courses.

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips