Microsoft Graph

The Microsoft Graph application that is used in PowerPoint is almost identical to that used to create charts in Excel.
Microsoft Graph supports several chart types and different types of charts are better suited to displaying different types of data.
So if you know how to create charts in Excel there are only a few subtle differences.

When you create or edit a chart. Microsoft Graph comes to life.
Rather than opening up another window, Microsoft Graph takes over the PowerPoint window and replaces the PowerPoint menus and toolbars with its own.
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.

To insert a chart on an existing slide choose Insert > Chart then just place and size the chart. When a graph is successfully customised save the graph as a custom chart type.

Charts Datasheet - View > Datasheet. To edit existing information select the cell and press F2
You can always change the value of single data series items by dragging the data member (only 2D charts though). Just click the data series and drag with the mouse although it is not that accurate

In 3D charts you cannot drag & drop data values

Creating a Charts

There are a large number of ways you can insert charts into your presentations.
1) Copy and Paste (traditional)
2) Copy and Paste (picture)
3) Linking (paste special)
4) Microsoft Graph (Insert > Chart)
5) Microsoft Chart (Insert > Object)
6) Importing (Insert > Picture)
7) Custom Solution (VBA)


Microsoft Graph has its own standard and formatting toolbars.

Different parts of a chart can be selected by clicking on the area or selecting it from the drop-down list.
Once selected you can click the Properties button to display the relevant properties.
When a Microsoft Graph is selected you can also display the Drawing, Picture and WordArt toolbars.

Datasheet Window

There is also a small datasheet windows which can be moved and resized when necessary

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.

alt text
alt text

The chart is formatted using the default template colours.

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.

alt text

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.

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) ??

alt textImport File - .

This will display the "Import File" dialog box.
Choose the Excel file you want to use and press Open.
choose Wsh
choose Range

alt text

It is possible to import data from text files as well.

Formatting a Chart

This is practically identical to formatting a chart in Excel ??
Please refer to the Excel charts section for more information.

alt text


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.
This is actually a separate application that uses OLE (Object Linking and Embedding) to insert objects from one application into another.

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext