eHow launches Android app: Get the best of eHow on the go.

How to Create a Bar Graph From an Excel Spreadsheet

Video Preview

Summary: Create a bar graph from an Excel spreadsheet by highlighting the information and clicking chart wizard from the toolbar. Make a bar graph with Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.

Views:
967
Presenter
By Amar Enhsaihan
eHow Presenter

Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.read more

Post a Comment

Post a Comment

Video Transcript

"Hi, I'm Amar Enhsaihan, I'm going to show you how to create a bar graph from Excel Worksheet. Go to Excel, you have information in Excel that you want to create a chart from. In my case I have sales data for ten years for three people, Bob, Sam, Kat, so let's say I want to create a bar chart. So, it's a little easier to see how they're doing. So, I highlight the information and then you have, you go to the tool bar, and you should have a button called chart wizard, you click on it, and if you don't have that button, make sure you click on the menu. Make sure that you have the bar chart, tool bar option checked. So, once you open that, this window opens up and the first option is a bar chart option, you click next, and this is how your chart is going to look like. You click next, and you have an option to enter a title, let's say sales for ten years, category X, that would be X here, so that's years, value Y, that would be sales, you click next. It asks where you want the chart, you can have it as an object in this worksheet, or you can have it in a separate sheet. I want it here, so as an object in graph, and you click finish. There it is, sales data for Bob, Sam, and Kat. You see years on X, axis, and you hit see sales on Y, axis, and you have the title here. And, that's how you create bar chart from Excel Worksheet. I'm Amar Enhsaihan, thank you for watching!"

eHow Article: How to Create a Bar Graph From an Excel Spreadsheet

Related Ads

  • Have you done this? Click here to let us know.
Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Computers
eHow_eHow Technology and Electronics