excel charts

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

Excel charts

resolvedResolved · Urgent Priority · Version 2007

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.

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

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

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@stl-training.co.uk

Regards

Stephen

RE: excel charts

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


 

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.06 secs.