Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel charts

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel charts

Resolved · Urgent Priority · Version 2007

Reply Mon 27 Jun 2011, 10:42Delegate Greg said...

Greg has attended:
Excel Intermediate course
Excel Advanced course

Excel charts

i have created a chart and it is sittingon top of the excel page. i want to copy and paste it to a Word doc and a ppt doc. how do i do this please.

also i want to place the chart on a separate sheet. i have tried the dialog box to do this but it does not work.

For upcoming training course dates see: Pricing & availability

Reply Mon 27 Jun 2011, 11:01Trainer Stephen said...

RE: excel charts

Hi Greg

Thanks for your question

To copy the chart into a word or powerpoint file, simply select the chart and copy to the clipboard. You can then go to the word document and then use the paste command to place it in the file. If instead of paste, you choose paste special-paste link, then any changes made to the chart in Excel will automatically update in word.

To set the chart into its own chart sheet. If you select the chart, then the format context ribbon will appear. At the extreme right of that ribbon is the location button. This allows you to choose to place the chart in its own sheet

Hope this helps

Regards

Stephen

Reply Mon 27 Jun 2011, 11:58Delegate Greg said...

RE: excel charts

THANKS STEPHEN.
I HAVE DONE BOTH THE SUGGESTED IDEAS BUT THEY DO NOT WORK FOR ME. AM I DOING SOMETHING INCORRECTLY?
GREG

Reply Wed 29 Jun 2011, 15:21Trainer Stephen said...

RE: excel charts

Hi Greg
That is difficult to answer without seeing exactly what you are doing. Could you email me a copy of the file, and I will see if the above strategy works for me. I may also be able to see where you are going wrong
my email is sw

Regards

Stephen

Reply Fri 1 Jul 2011, 08:59Delegate Greg said...

RE: excel charts

thanks stephen but i still cant get this to work. i will keep trying thanks. greg

Excel articles

· How to start using Excel 2007 Functions
· Chart Creation Simplified - in 4 Simple Steps
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Some Lesser Known Time Saving Tips In Excel
· How To Use The New Excel Web App

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

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips

Please tell us/web development about this error (copy and paste into an e-mail):
MySQL error: Duplicate entry '5' for key 'PRIMARY'
Line: 76
Actual SQL Query: insert into best_activevisitors (activevisitors_ID, activevisitors_IP, activevisitors_Time, activevisitors_Url) values (5, "38.107.179.243", now(), "/cms/forum.php")
Reported by: function sqlQueryBest()
When viewing (PHP_SELF): /cms/forum.php
Query string from URL: fpost_id=29466