Charts and Lesson on How to Connect Powerpoint to Excel

Yesterday the teacher taught us how to make charts on Excel, and also how to put information from Excel to PowerPoint. First we must make a data set, it is quite simple you only need text, and values, no formula. You can make one up or actually make a survey here is a sample:



Favourite Food

Pizza 8

French Fries 6

Hamburger 5

Taco 7

Lasagna 10

Pasta 9



But remember you have to put the text and the values in separate cells or else it will mess up. So I suggest you put the text in 1 column and then the values on the next column. After doing so, it is quite simple, just click highligh all the cells that are in the data set then make a chart, it is quite simple to make a chart, the steps are:

Making a chart (Microsoft Excel 2007):

Highligh Information, Inset, Chart, Select your chart
Insert, Chart, Highlight Information, Select your chart

You can highlight information before or after clicking insert chart but i like highlighting it before. When your chart is made you are bascially done. You can edit the coulour by clicking on the bar that you want to change the colour,then click on the right mouse button, then format data point, fill, solid, then choose your colour, when doing this the legend adjusts itself. You can also move it to a different sheet. You can also move the chart to another sheet by clicking on the right mouse button why left clicked it, then go to move chart then chose the sheet you want it.

One important thing you should always save on the sheet that you want to put on the power point, or else it will show someother page instead of the page you wanted. So now save in on the sheet that your chart or whatever you desire is in, now open power point.

When you open powerpoint there are 2 ways to put the chart form excel onto power point:

Insert Excel Chart on PowerPoint (Microsoft Excel 2007):

1. Right Mouse button, Copy, Go to power point, right mouse button, paste
2. Insert, Object, Create from file, browse, choose the saved excel file, then expand it to the right size, double click until it grows then the you can scroll around, scroll until you can see the cart double click outside this space.

Remember when putting things on PowerPoint you should always save at the Sheet you want to be made into a object, this is important. The advantages of the 2nd way is you can change it if you made a mistake on the data set, making life alot easier. When you coppy and paste the object is dead so you cannot change it if you made a mistake you have to change the data on excel, then make another object, which takes alot more time. Using Excel to make charts, and putting these charts on powerpoint makes life alot easyier.