DREW NOAH: So now, I'll show you how you can make a chart in Google spreadsheets using the information you have made. I just made up some simple information here that I'm going to make a chart with. And I'm going to make a bar graph for it. And each bar will be labeled, like January, and then each--all the information will show will be these two columns. And if I added more columns, right now, there's going to be two columns under January. But if I added more, there would be obviously more. But they'll probably be more clearer when I make the chart. So I'm just going to highlight where I want to make a chart from, and then just go up to this little pie chart symbol and add a chart. And you get this little pop-up right here. And here are the types of charts you can make. You have columns, bars, pie, line, area and scatter. You can add some labels. It chose the data that I selected, but if I want to alter it down here I could do that. And you can group data by rows or columns, and then use row 1 as labels which I want to do, and then use column A as labels. So you can see a little preview of what it looks like. Remember I said it's pulling two things of information for January. And if I add more, there would be more bars under the January right here. But you also have subtypes for each type of chart. So there's just a whole bunch of different options. And I mean one of those, just like right here, is just like a 3-D. So that's pretty cool. And then there's like stack version. And then you have bars. It's almost the same thing as column but it's just horizontal. You can see that. And then the same thing, there's a 3-D and then this stack kind. Then you have a pie chart which doesn't really work for what I'm using it for. It will probably work better with just one set of information. So it's taking the month and then the number next to it as a percentage of a whole. So it works--it sort of works just like this is income, so I can see the most income was made in May. But for my purpose, column works better. I just want to show you. And the subtypes for a pie chart are just a flat pie chart and a 3-D pie chart. Then they have the lines. And then you see all these different subtypes with dots, dots with no lines, curve and curve with dots. And then you can see a little preview of it, how that works. And this works pretty well for my information as well. So I can see when my bills are actually more than the income. And then they have area which is real similar to the lines. It's just
shaded underneath with similar subtype. And then scatter which is just dots where all the information lies. So let's do a 3-D column. There you go. And the label is right here. You can fill in all this information and give it a second to load because it's constantly updating this preview down here. Your horizontal axis is the date; vertical axis is money. And then you can choose where you want to put your legend. Let's put it on the left instead. Oop, there it goes. See, I switched it over. So once I'm done getting the chart I want--and like I said just watch the preview, it's really convenient. I just want to click Save chart. I'd give it one second to create it, and there it is. Right there. And I can click on something. Let's get this little pop-up box. There's nothing in there right now. But I've got more chart options right here: to edit chart, to go back to where I was, and delete it. Then I could save the image and I can also just publish just this chart. So these are the basics of making a chart, and the more you're used to--you to getting making charts, the more advanced charts you'll be able to make.
More Photos
