Difference between revisions of "In-Cell Chart Designer"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (18 intermediate revisions by 3 users 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| | + | :* 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 11: | Line 11: | ||
The specific dialog that is displayed depends on which chart type has been selected for the In-Cell Charts: | The specific dialog that is displayed depends on which chart type has been selected for the In-Cell Charts: | ||
| − | + | ||
| − | + | {| class="wikitable" border="1" | |
| − | + | |- | |
| − | + | ! Chart Type | |
| − | + | ! Chart | |
| − | + | |- | |
| − | + | | [[SparkLine Chart Designer]] (including area charts) | |
| − | + | | [[File:sparkline-1.png|centre]] | |
| − | + | |- | |
| − | + | | [[SparkColumns Chart Designer]] | |
| − | + | | [[File:sparkcolumns-1.png|centre]] | |
| − | + | |- | |
| − | + | | [[SparkWinLose Chart Designer]] | |
| + | | [[File:winlose-1.png|centre]] | ||
| + | |- | ||
| + | | [[SparkBar Chart Designer]] | ||
| + | | [[File:sparkbar-1.png|centre]] | ||
| + | |- | ||
| + | | [[SparkBullet Chart Designer]] | ||
| + | | [[File:sparkbullet-2.png|centre]] | ||
| + | |- | ||
| + | | [[SparkIcon Chart Designer]] | ||
| + | | [[File:sparkicon-1.png|centre]] | ||
| + | |- | ||
| + | | [[SparkHeatMap Chart Designer]] | ||
| + | | [[File:heatmap-1.png|centre]] | ||
| + | |- | ||
| + | | [[SparkPie Chart Designer]] | ||
| + | | [[File:sparkpie-1.png|centre]] | ||
| + | |- | ||
| + | | [[SparkHorizon Chart Designer]] | ||
| + | | [[File:sparkhorizon-1.png|centre]] | ||
| + | |- | ||
| + | | [[SparkBox Chart Designer]] | ||
| + | | [[File:sparkbox-1.png|centre]] | ||
| + | |- | ||
| + | | [[DotPlot Chart Designer]] | ||
| + | | [[File:dotplot-1.png|centre]] | ||
| + | |- | ||
| + | | [[Lollipop Chart Designer]] | ||
| + | | [[File:lollipop-1.png|centre]] | ||
| + | |- | ||
| + | | [[Bandline Chart Designer]] | ||
| + | | [[File:bandline-2.png|centre]] | ||
| + | |- | ||
| + | | [[Comparison Chart Designer]] | ||
| + | | [[File:ComparisonGrid1.png|centre]] | ||
| + | |} | ||
| + | |||
[[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 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:
