- 2 Minutes to read
- Print
- DarkLight
- PDF
Web Chart Formatting and Types
- 2 Minutes to read
- Print
- DarkLight
- PDF
Article Summary
This article lists supported chart types and formatting options in SpotlightXL and Web, including bar, column, line, pie, radar, and scatter charts. It also outlines Excel-style formatting features like font, borders, colors, and image support, along with print settings and unsupported chart types such as bubble and waterfall charts.
Below are the available options for designing a report:
Chart Formatting Supported
Chart Title - Text (SpotlightXL and Web)
Chart Legend (SpotlightXL and Web)
Chart Color Palette (SpotlightXL and Web)
Chart Style (SpotlightXL and Web)
Chart Tooltip (SpotlightXL and Web)
Chart Position (SpotlightXL and Web)
Bar Chart
Clustered Bar (SpotlightXL and Web)
Stacked Bar (SpotlightXL and Web)
100% Stacked Bar
3D Clustered Bar (SpotlightXL and Web)
3D Stacked Bar (SpotlightXL and Web)
Note: This is not supported in Excel 2016.
3D 100% Stacked Bar (SpotlightXL and Web)
Note: This is not supported in Excel 2016.
Column Chart
Clustered Column (SpotlightXL and Web)
Stacked Column (SpotlightXL and Web)
100% Stacked Column (SpotlightXL and Web)
3D Clustered Column (SpotlightXL and Web)
Note: This is not supported in Excel 2016.
3D Stacked Column (SpotlightXL and Web)
Note: This is not supported in Excel 2016.
3D 100% Stacked Column (SpotlightXL and Web)
Note: This is not supported in Excel 2016.
3D Column (SpotlightXL and Web)
Line Chart
Line (SpotlightXL and Web)
Stacked Line (SpotlightXL and Web)
100% Stacked Line (SpotlightXL and Web)
Line with Markers (SpotlightXL and Web)
Stacked Line with Markers (SpotlightXL and Web)
100% Stacked Line with Markers (SpotlightXL and Web)
3D Line (SpotlightXL and Web)
Pie Chart
Pie (SpotlightXL and Web)
3D Pie (SpotlightXL and Web)
Pie of Pie (SpotlightXL and Web)
Bar of Pie (SpotlightXL and Web)
Doughnut (SpotlightXL and Web)
Radar Chart
Supported in SpotlightXL and Web.
Scattered Charts
Supported in SpotlightXL and Web.
Other Unsupported Chart Types in SpotlightXL
Combo Chart
Surface and Surface 3D Chart
Stocks Chart
Bubble Chart
Waterfall Chart
Hierarchy Chart
Funnel Chart
Histogram
Box & Whisker Chart
Tree Map Chart
Sunburst Chart
Excel Formatting Supported
Font Size
Bold
Italic
Underline
Double Underline
Background Color
Text Color
Style
Border - Top
Border - Right
Border - Bottom
Border - Left
Border Style
Border Properties*
Border Color
Alignment - Left
Alignment - Center
Alignment - Right
Indentation
Format - Number
Format - Currency
Format - Percent
Column Width
Row Height
Hide Gridlines
Hide Headers
Images in Reports*
Print Property* (not supported in Spotlight)
*Border Properties - All border properties are supported in SpotlightXL except 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 before 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.