presentaid
  • Features
  • Pricing
  • Start free Trial
  • Support
    • EN
    • DE

Search

User Guide

Getting Started
  • Installation
  • First Steps
Dynamic Grid
  • Introduction to the Dynamic Grid
  • How to create a Dynamic Grid
  • How to work with a Dynamic Grid
  • How to modify an existing Dynamic Grid
  • How to create a Design for the Dynamic Grid
  • How to populate a Dynamic Grid Template (Render Mode)
Clever Cluster
  • How to work with the Clever Cluster
Smart Sticker
  • How to work with Smart Stickers
Quick Styles
  • How to work with Quick Styles
Efficiency Booster
  • Save/Send Selected Slides
  • Highlight/Transparent Overlay

Technical Support

  • Updates
  • Organization wide roll-out
  • Troubleshooting: Add-ins are missing in Office
  • Home
  • Knowledge Base
  • User Guide
  • Dynamic Grid
  • How to work with a Dynamic Grid

How to work with a Dynamic Grid

Table of Contents
  • Add/Delete Columns
  • Column Configuration
    • Grouping of Columns
    • Change Column Type
    • Add a Total Line
    • Change the Format of Number and Date Columns
    • Conditional Format
  • Grid Configuration
    • Designs
    • Total Line
    • Grid Margin
    • Seperator

Add/Delete Columns #

To add a column you can simply click on the column header in the task pane. presentaid will guess the most suitable column type based on the underlying data.

To remove a column select a shape of that column and delete it. The Dynamic Grid will notice this change and remove the entire column.

Column Configuration #

Grouping of Columns #

The grouping parameter helps to visually connect data rows with the same value. The Grouping logic can be changed in the taskpane.

Let’s assume we have the following data snippet:

If we apply “No Grouping”, the Dynamic Grid will generate a shape for each cell:

If you apply “ValueGrouping” to the first and second column the result looks as follows:

If you apply “ExcelGrouping” to the first and second column the grouping is based on merged cells in Excel:

Change Column Type #

To change the column type select a cell of the column that you’d like to change. In the dropdown above the column you can select your preferred column type.

Add a Total Line #

For Number Columns you can add a total line at the bottom of the Dynamic Grid. You can either show the sum or the average of the column.

Change the Format of Number and Date Columns #

In case you want to change the display format of a number or date column, select a shape in the column that you’d like to change and open the “Format” box in the taskpane.

Conditional Format #

With the conditional format you can add additional styles based on the content of a cell in the Dynamic Grid. Let’s assume you have created the following Grid and you want to change the background color of the “Sales” items in the second column:

  1. Select that column for which you want to apply a conditional format
  2. Click on “Advanced Conditional Formatting” in the taskpane
  3. Add a Rule, e.g. Value is equal to “Sales” and define your style, e.g. a grey background
  4. The conditional format will now be applied to all cells in the column which match the rule.

Grid Configuration #

Designs #

With Designs you can apply different layout styles to the entire Dynamic Grid. This is useful if you want you apply different styles for different client or if you have different reporting formats within your company. How to create a Design.

Total Line #

Enable or disable the total line of the Dynamic Grid.

Note: The total line is only shown for Number columns.

Grid Margin #

The margin defines the space between the columns and rows of the Dynamic Grid.

Seperator #

The seperators are the lines between each row of the Dynamic Grid. You can enable/disable them column by column or use this global configuration in the Grid settings pane.

How to create a Dynamic GridHow to modify an existing Dynamic Grid
Table of Contents
  • Add/Delete Columns
  • Column Configuration
    • Grouping of Columns
    • Change Column Type
    • Add a Total Line
    • Change the Format of Number and Date Columns
    • Conditional Format
  • Grid Configuration
    • Designs
    • Total Line
    • Grid Margin
    • Seperator
  • Imprint
  • Privacy Policy
  • Career
  • Contact

© 2023 presentaid

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie SettingsACCEPT
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
SAVE & ACCEPT