XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "In-Cell Chart Designer"

 
(5 intermediate revisions by 3 users not shown)
Line 16: Line 16:
 
! Chart Type
 
! Chart Type
 
! Chart
 
! Chart
 
 
|-
 
|-
 
| [[SparkLine Chart Designer]] (including area charts)
 
| [[SparkLine Chart Designer]] (including area charts)
| [[File:sparkline-1.png]]
+
| [[File:sparkline-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkColumns Chart Designer]]  
 
| [[SparkColumns Chart Designer]]  
| [[File:sparkcolumns-1.png]]
+
| [[File:sparkcolumns-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkWinLose Chart Designer]]
 
| [[SparkWinLose Chart Designer]]
| [[File:winlose-1.png]]
+
| [[File:winlose-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkBar Chart Designer]]  
 
| [[SparkBar Chart Designer]]  
| [[File:sparkbar-1.png]]
+
| [[File:sparkbar-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkBullet Chart Designer]]  
 
| [[SparkBullet Chart Designer]]  
| [[File:sparkbullet-2.png]]
+
| [[File:sparkbullet-2.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkIcon Chart Designer]]  
 
| [[SparkIcon Chart Designer]]  
| [[File:sparkicon-1.png]]
+
| [[File:sparkicon-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkHeatMap Chart Designer]]  
 
| [[SparkHeatMap Chart Designer]]  
| [[File:heatmap-1.png]]
+
| [[File:heatmap-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkPie Chart Designer]]  
 
| [[SparkPie Chart Designer]]  
| [[File:sparkpie-1.png]]
+
| [[File:sparkpie-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkHorizon Chart Designer]]  
 
| [[SparkHorizon Chart Designer]]  
| [[File:sparkhorizon-1.png]]
+
| [[File:sparkhorizon-1.png|centre]]
 
 
 
|-
 
|-
 
| [[SparkBox Chart Designer]]  
 
| [[SparkBox Chart Designer]]  
| [[File:sparkbox-1.png]]
+
| [[File:sparkbox-1.png|centre]]
 
 
 
|-
 
|-
 
| [[DotPlot Chart Designer]]  
 
| [[DotPlot Chart Designer]]  
| [[File:dotplot-1.png]]
+
| [[File:dotplot-1.png|centre]]
 
|-
 
|-
 
| [[Lollipop Chart Designer]]  
 
| [[Lollipop Chart Designer]]  
| [[File:lollipop-1.png]]
+
| [[File:lollipop-1.png|centre]]
 
|-
 
|-
 
| [[Bandline Chart Designer]]  
 
| [[Bandline Chart Designer]]  
| [[File:bandline-2.png]]
+
| [[File:bandline-2.png|centre]]
 +
|-
 +
| [[Comparison Chart Designer]]
 +
| [[File:ComparisonGrid1.png|centre]]
 
|}
 
|}
  
Line 71: Line 63:
 
[[Category:In-Cell Charts]]
 
[[Category:In-Cell Charts]]
 
[[Category:In-Cell Charts Getting Started]]
 
[[Category:In-Cell Charts Getting Started]]
 +
[[Category:Visualisations]]

Latest revision as of 12:04, 12 March 2020

This dialog is used to format any In-Cell Charts in your report, and can be invoked in several ways:

For In-Cell Chart formulae
  • While inserting an In-Cell Chart formula, after choosing the desired chart type, clicking the ... button under Chart Format
  • Right-clicking on an existing In-Cell Chart or formula, then selecting XLCubed > Format In-Cell Chart...
  • Double-clicking on an existing In-Cell Chart or formula
For Grid-based In-Cell Charts
  • While inserting an In-Cell Chart member, after choosing the desired chart type, clicking the ... button under Chart Format
  • In the Report Designer or the Hierarchy Editor, existing In-Cell Chart members have a ... button to format the chart

The specific dialog that is displayed depends on which chart type has been selected for the In-Cell Charts:

Chart Type Chart
SparkLine Chart Designer (including area charts)
Sparkline-1.png
SparkColumns Chart Designer
Sparkcolumns-1.png
SparkWinLose Chart Designer
Winlose-1.png
SparkBar Chart Designer
Sparkbar-1.png
SparkBullet Chart Designer
Sparkbullet-2.png
SparkIcon Chart Designer
Sparkicon-1.png
SparkHeatMap Chart Designer
Heatmap-1.png
SparkPie Chart Designer
Sparkpie-1.png
SparkHorizon Chart Designer
Sparkhorizon-1.png
SparkBox Chart Designer
Sparkbox-1.png
DotPlot Chart Designer
Dotplot-1.png
Lollipop Chart Designer
Lollipop-1.png
Bandline Chart Designer
Bandline-2.png
Comparison Chart Designer
ComparisonGrid1.png