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 PowerPoint 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. 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 PowerPoint 2) Insert your shapes in to any PowerPoint Slide from the Insert Ribbon 3) Select your shape and Press CTRL+C to copy the shape or Right Click and select Copy 4) Right Click on the desired table cell and select “Format Shape” 5) From the Format Shape Fill section,
a) Choose Picture or Texture Fill
6) Adjust the Offsets until your shape lo When your shape is inserted, it will fill up the entire cell. 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. You have now inserted a shape that is connected to a table cell in PowerPoint. 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.