Charts & Graphs

For this slide we’ll be creating a bar chart that shows what jam/jelly folks like the most in their peanut butter sandwiches. To create this type of slide we’ll start by clicking-on the same image we did for Slide 3. In the lower right corner of your screen you should still see the image to the right- Text and Content Layouts . Click-on the left image as you did before.

Click on the · Click to add text box and type: 100 Children and adults were surveyed to find out what goes best with peanut butter. 33 Selected grape jelly, 11 honey, 46 strawberry jam and 10 sliced bananas (you don’t have to tap enter, as this is one long statement).

In the right side area of the slide we’ll click on the center small icon in the top row (it looks like a bar chart – see arrow at right). When you click-on this icon, the images below will appear

At the top of the slide you will see an image that looks like the one above left. This is called a datasheet. If you have used any spreadsheet (like Microsoft Excel) you will be familiar with this format. If not, it won’t be a problem for what we are going to do.

Below the datasheet, you will see an image like the one on the left. The data in the above image created the bar chart you see to the right. As you enter data you will see the chart on the right change to reflect your data entries.

We are going to enter data for our graph in the Datasheet (from the sentence we entered above). Your Datasheet should now look like the one below – when you have entered the data. Click-on the box with “East” and replace “East” with (type-in) Grape, then “West” with Honey, “North” with Straw, and in the blank cell (box) below Straw enter Banana. Now, click on “1st Qtr” and type-in Best. Now click-on the cell (box) in the “A” column next to Grape and enter 33, then by Honey enter 11, by Straw enter 46, and by Banana enter 10. After you have entered the 10, click at the top of your datasheet on the word Best.

Note: As you are changing the labels and numbers you’ll see the graph that appeared with this datasheet changing to reflect the changes. This is an interactive graph. Really neat – you can see your graph “forming” as you type.

We want a simple graph that “fills” our graph area, so we need to delete the rest of the columns. To do this, put your cursor on the B in the Gray area at the top of the Datasheet. Click and hold down the left mouse button and drag right (over the Gray B, C and D) until B, C and D are highlighted (as shown below). Release the mouse button. Your Datasheet should now look like this:

Now tap the Delete key on the keyboard and the columns you have highlighted will disappear.

Every now and then you might make a mistake in the Datasheet. If you have “closed” the datasheet, as we did above (when we clicked-on the small X), you can get it back by clicking-on the Datasheet button below the Menu Bar.

You may or may not desire to alter the appearance of your graph. It should be OK. However, the graph may need some adjusting, so that all of the “words” show completely. You may want to change the size of the graph “box.” To do this, click-on one of the “grabber” boxes on the side, or corner (like you did previously), and drag the side or corner until the graph gets larger or smaller. If you make the graph wider, the word “Best” will move to one line. Click-on the legend (the small box with the grape, honey, etc. inside) and move that whole box to the top right hand part of the graph figure to make it more legible. Work with the various “parts” of the graph until it looks OK. If you make any changes, click-away from the graph to “turn off” the “box” around the graph – so you can see the new slide button.

Slide 6