How-to Add a Shape to a PowerPoint Table and Make it Move and Size with the Table Cell

As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives.

Typically, company executives don’t want to see lots of words, they just want a table and a quick visual of progress.

Also, most status reports are created and displayed in PowerPoint.

Now comes our problem:

1) You create your status report in a basic table in PowerPointimage_thumb.png 2) You insert shapes into the table cells that represent your status colors like Green for Good, Yellow for Cautious and Red for in trouble.image_thumb.png 3) Then you realize that your table looks better on the the left side of the PowerPoint slide deck.  And…as you move your table to the left, you notice that your table is moving but the status colors are not 🙁

So what can we do to lock in the shapes in a PowerPoint cell?

Here is one way to do this:

Step-by-Step 1) Insert/Create your table in PowerPointimage_thumb.png   2) Insert your shapes in to any PowerPoint Slide from the Insert Ribbonimage_thumb.png   3) Select your shape and Press CTRL+C to copy the shape or Right Click and select Copyimage_thumb.png   4) Right Click on the desired table cell and select “Format Shape” image_thumb.png   5) From the Format Shape Fill section,

a) Choose Picture or Texture Fill

b) Press Clipboard to Insert your Shape in the Table Cellimage_thumb.png

6) Adjust the Offsets until your shape lo When your shape is inserted, it will fill up the entire cell. image_thumb.png We need to add some spacing around the shape to make sure it looks normal.  You can do this by increasing the Offset values in the Fill pop-up menu.image_thumb.png   You have now inserted a shape that is connected to a table cell in PowerPoint. Project Status Report PowerPoint Table Shape 10 This will save you tons of time as you format and change your presentation.  To change status colors to one of the other status’, you just need to copy the original shape you inserted again and format the cell of the table like you did before.

Don’t you wish PowerPoint was more like Excel? 🙂

Video Demonstration Here you can watch the step-by-step process first hand:

File Download Here you can see the final result and play with it yourself. PowerPointShapeInsertedintoTableCell.pptx

Do you have to use PowerPoint a lot in your position?  I find that I have to use a combination of Microsoft Excel, Word, PowerPoint, Project and Visio in that order.  Let me know the tools that you use in the comments below.