Affiliates

Amazon.com


Popular Microsoft Excel Books

Excel 2003 Bible
Excel 2003 Bible
Author: John Walkenbach 

Excel 2003 for Dummies
Excel 2003 for Dummies
Author: Greg, PhD Harvey 

Microsoft Office Excel 2003 Step by Step
Microsoft Office Excel 2003 Step by Step
Author: Curtis Frye 

Excel VBA Programming For Dummies
Excel VBA Programming For Dummies
Author: John Walkenbach 

Excel 2003 Personal Trainer
Excel 2003 Personal Trainer
Author: Inc 

Microsoft Office Excel 2003 Inside Out
Microsoft Office Excel 2003 Inside Out
Author: Craig Stinson 

Excel 2003 All-in-One Desk Reference for Dummies
Excel 2003 All-in-One Desk Reference for Dummies
Author: Greg Harvey 

Popular MS Excel Related Websites

Microsoft Corporation 













Microsoft Excel 2007 Tutorial for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

  Microsoft Excel Tips and Tricks for beginners
Create Charts {Tutorial for beginners}  
 
Written by Upendra Kumar  
Saturday, 07 July 2007
Category MS Excel 2007 - Misc.  
 
General Information
 
 
Creating a basic Chart
 
 
Graphs offer a visual representation of the data. Instead of having to analyze columns of values of spreadsheet, it can interpret the meaning of the data of a single look. A graph transmits the messages quickly. With a graph, the data of spreadsheet can be transformed to show comparisons, patterns and tendencies.  
 
Creating a basic Chart
 
1) Open the Table Usage.xlsx Sample.
 
Illustration 1: Table usage sample excel file.
 
2) Select the data that wish to represent, including the titles of the columns.
 
3) Next, it clicks in the Insert Group and, in the sub group Charts, click in the Column button.
 
Illustration 2: Creating Graphs.  Click here to view larger image.
 
4) The chart will be created and placed near the data table.
 
Illustration 3: New chart created.  Click here to view larger image.
 
5) After creating a graph, you can add new elements easily. For example, you can add titles to it to offer more information or change the element's position.
 
6) When creating a graph, in the Options Tape appears the Graph's Tools, which include Design, Distribution and Format groups. In these groups youwill find the commands necessary to work with the graphs.
 
Illustration 4: Chart Tools.
 
7) When the graph is finished, click outside it. The Graph's Tools will disappear. Click within the graph so that they will be displayed again.
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster