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 >