Home     PowerPoint     Photoshop     Photos     Other     Studio     Info

Bookmark and Share  



 

 

Inserting Charts in PowerPoint 2007

Author: Geetesh Bajaj

Product/Version: PowerPoint 2007

Date Created: April 12th 2007
Last Updated: February 25th 2009


Excerpt/Capsule:.


Product Showcase




Before You Begin: If the data on which you want to base your chart is already available within Excel 2007, create your chart in Excel, and then copy-paste it into a PowerPoint slide.

Follow these steps to inserting a new chart in PowerPoint 2007:

  1. Create a new presentation in PowerPoint, or open an existing presentation.

  2. When you insert a new slide in PowerPoint, it uses the default Title Slide layout.

    Note: Learn more about inserting a new slide in PowerPoint 2007 here...

  3. Click the Layout button/option in the Home tab of the Ribbon to bring up the Layout gallery as shown in Figure 1.

    Select any of the layouts that include a content placeholder (the small palette like collection of multicolored buttons visible on some of the slide layouts shown in Figure 1).

    Slide Layout
    Figure 1: Choose a slide layout

  4. If your slide layout has a content placeholder, click the chart button among the six buttons in the content placeholder that you can see in the slide within Figure 2.

    Content Placeholer
    Figure 2: Content Placeholder

    Alternatively, if you want to insert a chart in an existing slide that has no content placeholder, just select the Insert tab of the Ribbon, and click the Chart button, as shown in Figure 3.

    Insert Chart
    Figure 3: Insert Chart

  5. Either of these options opens the Insert Chart dialog box that you can see in Figure 4.

    Insert Chart
    Figure 4: Insert Chart

    The left column lists the types of charts that you can create in PowerPoint -- and the area towards the right shows several chart possibilities using a selected chart type.

    Select a particular chart variant -- if you can't find the chart variant you want, just choose something similar to the one you want (editing it later which is easy). Click OK.

  6. This will place a chart on the slide that is based on dummy data. At the same time, this launches Microsoft Excel in a separate window as shown in Figure 5, containing the dummy data of the chart.

    Chart and Excel with dummy values
    Figure 5: Chart and Excel with default values

    Note: If you don't have Excel 2007 installed on the same system as PowerPoint 2007, then you'll see Microsoft Graph instead of Microsoft Excel -- this works exactly the same way as in versions 2002 and 2003 of PowerPoint -- look here...

  7. You now need to replace the dummy data in the Excel sheet with your own data. Follow these guidelines:

    1. Select a cell in the Excel sheet, and enter the new value.

    2. You can move to the cell towards the right in the Excel sheet by pressing the tab button. Or move to cell down by pressing the Enter (Return) key.

    3. To insert a new column in the Excel sheet, right-click the header of the next column and choose the Insert option.

    4. To insert a new row in the Excel sheet, right-click the header of the next column and choose the Insert option. Remember, column or row content inserted this way ends up as a new series value in your chart.

    5. You can also delete columns and rows -- just select the row or column header, right-click, and choose the Delete option.

  8. Refer to Figure 5 above which has default chart values, the changed values can be seen in Figure 6.

    If you can't see the values in Figure 5 because they are so small in size, just trust me when I say the values were different from what you see in Figure 6!

    Changed values
    Figure 6: Changed values

  9. Any changes you make in the Excel sheet (refer to Figure 6 above) will reflect as changes on the chart within PowerPoint, as shown in Figure 7.

    Chart
    Figure 7: Updated chart in PowerPoint

  10. Close Microsoft Excel to apply those changes on the chart (see Figure 8).

    Inserted Chart
    Figure 8: Inserted Chart

  11. To make more changes, select the chart so that the Ribbon area shows the Chart Tools Design tab as shown in Figure 9. Now click the Edit Data button -- this opens the Excel sheet again, where further changes in the values can be made.

    Edit data
    Figure 9: Edit data


    Tip: You can also right-click the chart, and choose the Edit Data option to achieve the same result.


 


Featured Story

Adobe Captivate's Edit View

In an earlier post last week, I discussed Adobe Captivate's views and compared them to PowerPoint's deafult views. I also explained about the Storyboard View. In this post, I'll look at Captivate's Edit view, which in many ways is similar to PowerPoint's Normal view. If you are not already in Edit view within Captivate, choose the View drop-down in the toolbar, and select Edit View.

Learn more here...


    
Featured Book

PowerPoint 2007 Complete Makeover Kit

PowerPoint 2007 Complete Makeover Kit
PowerPoint 2007 Complete Makeover Kit is out! Check the book on Amazon.com...

And here are some free excerpts...


Home |  PowerPoint |  Photoshop |  Templates |  Blog |  Notes |  Ezine |  Studio |  Advertise |  Feedback |  Info |  Site Map
Store  |  RSS |  Privacy |  Testimonials
Free PowerPoint Backgrounds | Free PowerPoint Templates | Free Christian PowerPoint Backgrounds
Page copy protected against web site content infringement by Copyscape
  Page copy protected against web site content infringement by Copyscape


  ©2000-2009, Geetesh Bajaj. All rights reserved.

    since November 02, 2000