Difference between revisions of "In-Cell Chart Designer"
(Created page with '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, a…') |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (30 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
This dialog is used to format any In-Cell Charts in your report, and can be invoked in several ways: | 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'' | + | :''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 |
| − | ''For Grid-based In-Cell Charts'' | + | :''For Grid-based In-Cell Charts'' |
| − | * While inserting an In-Cell Chart member, after choosing the desired chart type, clicking the {{Code|...}} button under {{Code|Chart Format}} | + | :* While inserting an In-Cell Chart member, after choosing the desired chart type, clicking the {{Code|...}} button under {{Code|Chart Format}} |
| − | * In the [[Report Designer]] or the [[Hierarchy Editor]], existing In-Cell Chart members have a {{Code|...}} button to format the chart | + | :* In the [[Report Designer]] or the [[Hierarchy Editor]], existing In-Cell Chart members have a {{Code|...}} button to format the chart |
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 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:
