How to Make a Demographic Chart

Next Video:
How to Program a PHP In-Text Advertising System....5

Making a demographic chart is something you can do in a few basic programs, like Microsoft Excel. Find out how to make a demographic chart with help from a computer programmer in this free video clip.

Part of the Video Series: Computer Science & Software
Promoted By Zergnet


Video Transcript

Hello. My name is Omar, and I'm a programmer. Today, I'm going to show you how to make a demographic chart. I don't have Microsoft Excel it should be the same process. I'm going to use It's free and to download and use. So, as you can see here I have the Excel like spreadsheet program that comes with Open Office 3. I have five cities that I called city 1, 2, 3, 4, 5. And let's say I have a number associated with them and that number is the number of say males or females or just any demographic you can think of. So in order to make a chart of that I just highlight the whole thing and I click on the chart icon. And once I do that I select the type of chart I want. I'm going to choose default one and I click finish. And once I do that as you can see I'll have a nice little demographic chart. So let's say you want a pie chart instead. So I have a bunch of demographics here, 1, 2, 3, and 4 and I have a number associated with those demographics. If I want a pie chart with that I'm going to go ahead and go to the bottom and click, and type equals sum, open parenthesis and I'm going choose all of these cells to get the total number. And once I do that I'm going to make another column here and I'm going to do 100, because we want the percentage. So we go 100 multiplied by the number divided by the total. And then we get the percentage for that particular number. And we're just going to go ahead and copy and paste here. And it's not going to work because it's going to increase the cell number. We're going to replace that with 24 on each line, we're talking about the denominator. We're going to replace that with 24 on each line and we get a nice percentage. So we highlight both of these, nothing else, just these. You could hold down control or command to highlight just one column at a time. And then we go ahead and click on chart. And this time the type of chart we'll choose is the pie chart. And once we do that we get a nice little pie chart of the demographics that you're interested in. See, easy as pie. I'm Omar, and I just showed you how to make a demographic chart. Have a good day.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!