Conditional Icons in PowerPoint


OfficeReports can place icons in tables and charts based on the background color or font color in the linked cell. You can use any PowerPoint shape as icon and you have define a combination of the shape name and a specific color. When using 'Conditional Icons', OfficeReports checks if the font or background of a linked cell in the workbook has been defined with a name. If it has, OfficeReports will first check for a shape with this name on the current slide and use that shape as icon. In case the shape is not found on the current slide, the first slide is checked. in case you always use the same icons in the same position, you can just add the icons (hidden) on slide 1.

The shapes OfficeReports uses for showing significant difference in PowerPoint tables and charts are already defined as hidden shapes on slide 1 of the presentation and are named 'SigHigh' and 'SigLow'. In case you show significance at 2 levels, the shapes for the second level are named 'SigHigh2' and 'SigLow2'. The colors for these icons are defined in the 'Table Layout' settings (which can be changed in the OfficeReports App) so they automatically match the background colors used by OfficeReports in Excel. You can add other icons and colors in the 'Conditional Icons' window:


When you select slide 1 and open the 'Selection Pane' (shortcut Alt-F10) you can see the 'hidden' shapes (click the 'small line/eye' to toggle visibility):

You can use any shape you like. In case you use arrows, you do not want the shape positioned on top of the number, but you want it moved to the right a bit. In the 'Alternative Text' (right-click the shape and select "Edit Alt-Text") of the shape you can define a text "<right offset>;<top offset>" so the icon is positioned correctly at once:

Use negative values to position the icon to the left or the bottom.