Difference between revisions of "In-Cell Chart Designer"

m (Text replacement - "XLCubed" to "FluenceXL")
 
(One intermediate revision by one other user not shown)
Line 3: Line 3:
 
:''For In-Cell Chart formulae''
 
:''For In-Cell Chart formulae''
 
:* While inserting an In-Cell Chart formula, after choosing the desired chart type, clicking the {{Code|...}} button under {{Code|Chart Format}}
 
:* While inserting an In-Cell Chart formula, after choosing the desired chart type, clicking the {{Code|...}} button under {{Code|Chart Format}}
:* Right-clicking on an existing In-Cell Chart or formula, then selecting {{Menu|XLCubed|Format In-Cell Chart...}}
+
:* Right-clicking on an existing In-Cell Chart or formula, then selecting {{Menu|FluenceXL|Format In-Cell Chart...}}
 
:* Double-clicking on an existing In-Cell Chart or formula
 
:* Double-clicking on an existing In-Cell Chart or formula
  
Line 57: Line 57:
 
|-
 
|-
 
| [[Comparison Chart Designer]]
 
| [[Comparison Chart Designer]]
| [[ComparisonGrid1.png|centre]]
+
| [[File:ComparisonGrid1.png|centre]]
 
|}
 
|}
  

Latest revision as of 07:34, 4 July 2023

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 FluenceXL > 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