When you have a large table and wish to export it to PowerPoint, one solution is to create smaller tables, each showing a different range of rows, and show them on multiple pages. This article describes how to go from a standard table...
...to a table or visualization that only displays a specified range of rows, e.g., only the Pepsi rows:
Requirements
- A table or visualization.
Note: You must apply the rule directly to the input table if you see a table icon in the Data > Data Source > Data field in the object inspector of a visualization.
You will also see a warning in the Rules section of the object inspector if you have applied a rule directly to a non-compatible visualization, and you will need to apply it to the input table instead. For example:
Method
- Configure your table as you'd like to show it, except for the range of rows.
- OPTIONAL: Duplicate the page with your table as many times as you need to be able to show all rows, given the ranges you'd like.
- You will need to apply the rule from the menu on each table individually (you can't add it once and use the apply menu to add it to selected items). Select the first table, and in the object inspector
, go to Data > Rules > Plus (+) > Rows/Columns > Show A Range of Rows.
- Specify the First row number to retain, e.g., 4.
- Specify the Last row number to retain, e.g,. 6.
- Press OK.
- Repeat steps 3-6 on the remaining tables individually.
Next