Web Chart Formatting and Types

2 Minutes to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

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.

Was this article helpful?

What's Next

Cascade Reporting in SpotlightXL

Table of contents