Web Chart Formatting and Types
- 2 Minutes to read
- Print
- DarkLight
- PDF
Web Chart Formatting and Types
- 2 Minutes to read
- Print
- DarkLight
- 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 (SpotlightXL and Web) |
Scattered Charts (SpotlightXL and Web) |
| Other Unsupported Chart Types in SpotlightXL |
Combo Chart |
Surface and Surface 3D Chart |
Stocks Chart |
Bubble Chart |
Water Fall 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?