Difference between revisions of "In-Cell Chart Designer"
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]] | ||
− | |||
|- | |- | ||
| [[SparkColumns Chart Designer]] | | [[SparkColumns Chart Designer]] | ||
| [[File:sparkcolumns-1.png]] | | [[File:sparkcolumns-1.png]] | ||
− | |||
|- | |- | ||
| [[SparkWinLose Chart Designer]] | | [[SparkWinLose Chart Designer]] | ||
| [[File:winlose-1.png]] | | [[File:winlose-1.png]] | ||
− | |||
|- | |- | ||
| [[SparkBar Chart Designer]] | | [[SparkBar Chart Designer]] | ||
| [[File:sparkbar-1.png]] | | [[File:sparkbar-1.png]] | ||
− | |||
|- | |- | ||
| [[SparkBullet Chart Designer]] | | [[SparkBullet Chart Designer]] | ||
| [[File:sparkbullet-2.png]] | | [[File:sparkbullet-2.png]] | ||
− | |||
|- | |- | ||
| [[SparkIcon Chart Designer]] | | [[SparkIcon Chart Designer]] | ||
| [[File:sparkicon-1.png]] | | [[File:sparkicon-1.png]] | ||
− | |||
|- | |- | ||
| [[SparkHeatMap Chart Designer]] | | [[SparkHeatMap Chart Designer]] | ||
| [[File:heatmap-1.png]] | | [[File:heatmap-1.png]] | ||
− | |||
|- | |- | ||
| [[SparkPie Chart Designer]] | | [[SparkPie Chart Designer]] | ||
| [[File:sparkpie-1.png]] | | [[File:sparkpie-1.png]] | ||
− | |||
|- | |- | ||
| [[SparkHorizon Chart Designer]] | | [[SparkHorizon Chart Designer]] | ||
| [[File:sparkhorizon-1.png]] | | [[File:sparkhorizon-1.png]] | ||
− | |||
|- | |- | ||
| [[SparkBox Chart Designer]] | | [[SparkBox Chart Designer]] | ||
| [[File:sparkbox-1.png]] | | [[File:sparkbox-1.png]] | ||
− | |||
|- | |- | ||
| [[DotPlot Chart Designer]] | | [[DotPlot Chart Designer]] |
Revision as of 15:28, 16 March 2015
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: