98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts imported from Excel
Charts imported from Excel
Resolved · High Priority · Version 2003
Tue 3 Aug 2010, 15:19Delegate Belinda said...
Belinda has attended:
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Charts imported from Excel
I am trying to import charts from Excel. According to your menu I can do it by Inserting Object, then create from file. However by doing so I have no control over which chart(s) in the workbook I am importing. When I saved 3 charts on the same tab and set print area to cover all 3 charts, only 1 corner of 1 chart appears in my PPT slide. Also by using this function does that mean I can't link the data to the slide?
Alternatively, when I click chart as an object in the slide, it allows me to import file by using the tool button. However I have no idea how to define the range despite several attempts. Can you please advise?
Further questions can I define the format of the charts on PPT in similar manner as Excel, or I have to change font, colour etc based on PPT editing?
Fri 6 Aug 2010, 11:26Trainer Nafeesa said...
RE: Charts imported from Excel
Hi Belinda
Thank you for your question regarding charts.
Inserting a chart as an object is definitely a valid method to link excel charts to a powerpoint slide, however if you have more than one chart present the entire contents of Excel will be inserted.
An alternative method is to copy the chart in Excel, switch to PowerPoint, Open the 'Edit' menu, selecting 'Paste Special' and putting a check next to 'Link'. Any changes made to Excel will be reflected in PowerPoint.
The formatting options available are identical in both PowerPoint and Excel, however with the charts being linked you will only be able to format the charts in Excel with the format changes being reflected in PowerPoint.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post.
Kind Regards,
Nafeesa
Microsoft Office Specialist Trainer
Fri 6 Aug 2010, 11:26Trainer Nafeesa said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display pictures on Chart Data PointReplacing a single chart data point bar with a picture. |
