![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft PowerPoint > Charts > Microsoft Graph | < Previous | Next > |
Step 1 - What is Microsoft Graph ? |
For more details about the Microsoft Graph application, please refer to the Microsoft Graph section. | ||
This allows you to add charts directly into PowerPoint and is discussed in detail on the following page. | ||
1) Type in your own data | ||
2) Import data from Excel | ||
3) Copy and paste from Excel |
You can double click on a chart to display Microsoft Graph menus and toolbars. |
Step 2 - Using Microsoft Graph |
The following default 3D chart will be created and a corresponding Data Table will also be displayed. | ||
Double click a chart object to open Microsoft Graph. |
![]() | |||
![]() |
The chart is formatted using the default template colours. |
Step 3 - Using the Data Table |
The datasheet is a separate window that supplies the data on which the chart is based. | ||
The Data Table can be resized and data from Excel can be copied and pasted into it. | ||
The first row of the table is used to contain the category axis values. | ||
The first column of the table is used to contain the series values. | ||
The second row starts at number 1 and the second column starts at letter A. | ||
It is possible to reverse the table and have the columns containing the data series. This can be done using the By Columns button on the standard toolbar. |
You can just type over this data and enter different data. | ||
It is also possible to copy and paste a range of cells from Excel into this table. |
![]() |
You can insert and delete rows and columns from the Data Table by using the Right mouse button. | ||
It is also possible to change the number format, font and even the width of your columns. |
It is possible to remove rows and columns from the chart simply by double clicking on the row or column heading twice. | ||
Alternatively you can use the (Data > Include/Exclude Row/Col) commands. |
Click anywhere on the slide outside the chart or the datasheet to exit Microsoft Graph and return to PowerPoint. |
Step 4 - Importing Data from Excel |
You can alternatively import your data from Excel using the Import File button on the standard toolbar. | ||
or use (Edit > Import File) ?? |
![]() | Import File - . |
This will display the "Import File" dialog box. | ||
Choose the Excel file you want to use and press Open. | ||
choose Wsh | ||
choose Range |
![]() |
It is possible to import data from text files as well. |
Step 4 - Formatting a Chart |
This is practically identical to formatting a chart in Excel ?? | ||
Please refer to the Excel charts section for more information. |
![]() |
Step 5 - Things to Remember |
You will only see the Data and Chart drop-down menus on the Menu bar when a chart is active. | |||
This is actually the same program that is used in Microsoft Word. |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | < Previous | Top | Next > |