|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
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 |
|
|
| |
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. |
| |
|
| |
|
|
|
|
|
|
|
|
|
|
