Excel is a powerful yet easy to use spreadsheet program. In many cases, Excel charts can be created to visually display complex information to the users. Excel 2010 has powerful new features to create impressive charts. When you want to present just the Excel chart and not the entire dataset to the audience, then the Microsoft PowerPoint application can be the right choice to do so. While PowerPoint has its own set of features to draw charts, it would be very difficult and time consuming to draw the charts in the PowerPoint slide that are already in the Excel workbook. As such it would be wise decision to export the charts from the Excel program to the PowerPoint program, or you could import the charts from the Excel program into the PowerPoint program. Either way will save you a considerable amount of time and effort.
Copy the Excel chart and paste it into a PowerPoint slide. To do this, follow the instructions below:
• Open the Excel file that contains the Excel chart. Go to the specific sheet and select the chart.
• From the Clipboard group of the Home tab choose Copy and click on it.
– You can also press the CTRL + C keys simultaneously.
• The chart is copied to the clipboard. Now go to the PowerPoint presentation.
• Open the PowerPoint presentation and select the slide where you want to paste the chart.
• From the Clipboard group of the Home tab choose Paste and click on it.
– For the keyboard shortcut press the CTRL + V keys.
– The chart will be pasted onto the PowerPoint slide.
• A small set of Paste Option icons will appear at the bottom of the pasted chart. Different options are there, choose the suitable options that will best suite your purpose.
• To keep the data in the PowerPoint slide the same as the data in the Excel workbook the chart should be linked to the source data. To link the chart in the PowerPoint slide to the Excel workbook select the option “Chart (linked to Excel data)” in the PowerPoint application. To view the chart as a static image, choose the ‘Paste as Picture’ option. To keep the original format, choose the option Keep Source Formatting. You can also choose the Use Destination Theme option to paste and format the chart by using the destination theme.
• To present the chart in a different design, its design can be changed by going to the design tab and clicking on the style form from the chart styles option.
• To view the chart as a motionless image you can use the Picture format and it will show a better quality image than the standard Bitmap format.
You can insert charts from an existing Excel workbook. You need not to recreate the chart in the PowerPoint presentation. You can import it from the Excel worksheet. Steps to do so are as follows –
• Open the PowerPoint presentation and go to the slide where you want to insert the chart.
• After activating the slide, go to the Insert tab and select the Object button from the Text group and click on it.
• For creating a new chart choose the Create New button. As for example for creating a new excel chart choose the MS Office Excel Chart.
• For inserting a chart which is already in an excel worksheet, click on the button Create from file, then click ok.
• Click on the Browse button and navigate to the file where the chart is. Select the file and click ok.
• There is a link box, click it if it is needed to keep a connection to the source file. Then click ok.
• Without pasting the chart one can display it as an icon. To do this, check the Display as icon check box then click ok.
• The icon of an excel workbook will be appeared on the slide. Drag it to the position where you want to set it.
• Resize and position the chart in the source file if necessary.
Among the above two processes, the first one is better. To know more about the procedures you should search the help files which are associated with the Excel program. You may want to speak with an Excel consultant for more specific details. There are many procedures and tips and tricks for different tasks in different versions of Microsoft programs on the internet. Visit the site and click on the program with which your problem is related to, then find out the required topics. This will certainly help you to solve your problem.
Excel consultant help for Business.
Kevin Martin is a Microsoft Office expert has been working in the technology industry for the last 6 years. As a technical expert, he has written white papers, and reviews for many websites such as office.com/setup | . www.office.com/setup