Dynamic Planning SpotlightXL User Guide Chart Formatting and Types

If you are designing a report that will be used from Spotlight on the Web, see Spotlight User Guide: Supported Chart Types and Formatting on the Web.

Support in SpotlightXL includes the following.

*Border Properties - All border properties are supported in SpotlightXL with the exception of Diagonal Borders (left and right). If selected in the design mode of a report, when the report is rendered they will be removed from the report entirely and they will also be removed from the Design mode.

*Images in Reports - All image types (for example, JPG, BMP, and PNG) that are supported by Microsoft Excel are also supported for Dynamic Planning. This includes the insertion of Clip Art. Image format properties such as size, effect, and crop (available under the Microsoft Excel FORMAT tab) are supported as long as the image is formatted prior to saving the report in SpotlightXL. There are no image size limitations or the number of images per report, however, we recommend you use no more than 3 images per report as performance may be impacted.

*Print Property - To save print settings for a specific report, open the report in Design Mode by selecting the Report task and the Design subtask. Select File, Print. Select print settings such as Orientation and Margins. Exit the Print menu and return to the SpotlightXL tab. Click Save. Print settings are now saved to the associated report. Print settings are report specific, however, they are not user specific.