Skip to Content

Wiki source code of 03cii. Charting

Last modified by Jeff Nicholson on 06/11/2025, 14:24
Hide last authors
Jeff Nicholson 1.1 1 {{box cssClass="floatinginfobox" title="**Contents**"}}
2 {{toc/}}
3 {{/box}}
4
5 The charting option is designed to be a way of quickly adding a single chart to a report. Saved [[Crosstabs >>doc:Technical Documentation.CXAIR.User Guide.02\. Reporting.2c\. Crosstabs.WebHome]]can be imported into [[Pages >>doc:Technical Documentation.CXAIR.User Guide.02\. Reporting.2e\. Pages.WebHome]]if multiple charts are required.
6
7 Select a chart from the **Chart Type** drop-down list. The chart library will only display chart types that are relevant to the data currently added to the [[Crosstab>>doc:Technical Documentation.CXAIR.User Guide.02\. Reporting.2c\. Crosstabs.WebHome]].
8
9 = Chart Types =
10
11 == Area Graphs ==
12
13 === Area ===
14
15 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
16 **Aggregations** – Choose to display one or more aggregations.
17
18 [[image:Area.png||height="410" width="720"]]
19
20 === Area (Multi-Series) ===
21
22 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
23 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
24
25 [[image:Area Multi.png||height="401" width="720"]]
26
27 === Area (Stacked) ===
28
29 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
30 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
31
32 [[image:Area Stacked.png||height="404" width="720"]]
33
34 === Area (Scrolling) ===
35
36 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
37 **Aggregations** – Choose to display one or more aggregations.
38
39 [[image:Area Scrolling.png||height="418" width="720"]]
40
41 === Spline Area ===
42
43 **Axes Requirements** – Will render chart against either Rows or Columns. To render the Rows, use the Switch Chart Axes option.
44 **Aggregations** – Only works with a single aggregation.
45
46 [[image:Spline Area.png||height="410" width="720"]]
47
48 === Spline Area (Multi-Series) ===
49
50 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
51 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
52
53 [[image:Spline Area Multi.png||height="411" width="720"]]
54
55 == Bar Charts ==
56
57 === Bar ===
58
59 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
60 **Aggregations** – Choose to display one or more aggregations.
61
62 [[image:Bar.png||height="412" width="720"]]
63
64 === Radial Bar ===
65
66 **Axes Requirements** – Will render chart against either Rows or Columns (not Rows and Columns).
67 **Aggregations** – Will only work with a single aggregation.
68 **Advanced Options** – Additional chart specific options in the **Advanced** **Options** section allow you to change the chart caption (default caption and hover caption) and specify the Inner Radius (the size of the blank space in the middle of the radial) of the chart (in pixels).
69
70 [[image:Screenshot 2022-04-22 at 13.35.04.png||height="646" width="720"]]
71
72 === Bar (Multi-Series) ===
73
74 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
75 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
76
77 [[image:Bar Multi.png||height="389" width="720"]]
78
79 === Bar (Stacked) ===
80
81 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
82 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
83
84 [[image:Bar Stacked.png||height="401" width="720"]]
85
86 === Bar 3D ===
87
88 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
89 **Aggregations** – Choose to display one or more aggregations.
90
91 [[image:Bar 3D.png||height="394" width="720"]]
92
93 === Bar 3D (Multi-Series) ===
94
95 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
96 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
97
98 [[image:Bar 3D Multi.png||height="397" width="720"]]
99
100 === Bar 3D (Stacked) ===
101
102 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
103 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
104
105 [[image:Bar 3D Stacked.png||height="380" width="720"]]
106
107 === Bar (Overlapped) ===
108
109 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
110 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
111
112 [[image:Bar Overlapped.png||height="397" width="720"]]
113
114 === Bar (Grouped) ===
115
116 **Axes Requirements** – Will render chart against either two Rows or two Columns.
117 **Aggregations** – Will only work with a single aggregation.
118
119 [[image:Screenshot 2021-05-04 at 15.13.08.png||alt="Screenshot 2021-05-04 at 13.59.24.png" height="671" width="720"]]
120
121
122 === Parallel Coordinates ===
123
124 **Axes Requirements** – Can use a single row (and multiple aggregations) or rows and columns (with a single aggregation).
125 **Aggregations** – Requires multiple aggregations when used with just a row. Requires a single aggregation when used with rows and columns.
126
127 [[image:PO.png||height="308" width="720"]]
128
129 == Column Charts ==
130
131 === Column ===
132
133 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
134 **Aggregations** – Choose to display one or more aggregations.
135
136 [[image:Column.png||height="432" width="720"]]
137
138 === Column 3D ===
139
140 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
141 **Aggregations** – Choose to display one or more aggregations.
142
143 [[image:Column 3D.png||height="398" width="720"]]
144
145 === Column (Multi-Series) ===
146
147 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
148 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
149
150 [[image:Column Multi.png||height="405" width="720"]]
151
152 === Column 3D (Multi-Series) ===
153
154 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
155 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
156
157 [[image:Column 3D Multi.png||height="395" width="720"]]
158
159 === Column (Stacked) ===
160
161 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
162 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
163
164 [[image:Column Stacked.png||height="418" width="720"]]
165
166 Please note that zero values are plotted when selecting this chart type.
167
168 === Column 3D (Stacked) ===
169
170 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
171 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
172
173 [[image:Column 3D Stacked.png||height="396" width="720"]]
174
175 Please note that zero values are plotted when selecting this chart type.
176
177 === Column (Scrolling) ===
178
179 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
180 **Aggregations** – Choose to display one or more aggregations.
181
182 [[image:Column Scrolling.png||height="418" width="720"]]
183
184 Please note that zero values are plotted when selecting this chart type.
185
186 === Column (Stacked Scrolling) ===
187
188 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
189 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
190
191 [[image:Column Stacked Scrolling.png||height="406" width="720"]]
192
193 Please note that zero values are plotted when selecting this chart type.
194
195 === Column (Dual Y Axis) ===
196
197 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
198 **Aggregations** – Requires two aggregations. Each aggregation is plotted against their own Y-axis.
199
200 [[image:Dual Y.png||height="405" width="720"]]
201
202 === Column 3D (Dual Y Axis) ===
203
204 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
205 **Aggregations** – Requires two aggregations. Each aggregation is plotted against their own Y-axis.
206
207 [[image:Column Dual Y 3D.png||height="412" width="720"]]
208
209 === Column Multi-Series (Dual Y Axis + Line) ===
210
211 **Axes Requirements** – Requires both Rows and Columns. It will render the Columns by default and use the Rows as the Series. Use the Switch Chart Axes option to switch the Row/Column usage.
212 **Aggregations** – Requires three or more aggregations. The last aggregation in the list will be rendered as the line. Re-arrange the aggregations to change which aggregation is rendered as the line.
213
214 [[image:Column Multi-Series (Dual Y Axis + Line).png||height="402" width="720"]]
215
216 === Column (Combination) ===
217
218 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
219 **Aggregations** – Can be used with two or more aggregations when just a Row or Column is used for the Axis. Can be used with one or more aggregations when both Rows and Columns are used for the Axes.
220
221 [[image:Column Combination.png||height="407" width="720"]]
222
223 === Column 3D (Combination) ===
224
225 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
226 **Aggregations** – Can be used with two or more aggregations when just a Row or Column is used for the Axis. Can be used with one or more aggregations when both Rows and Columns are used for the Axes.
227
228 [[image:Column 3D Combination.png||height="392" width="720"]]
229
230 === Column (Combination Scrolling) ===
231
232 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
233 **Aggregations** – Can be used with two or more aggregations when just a Row or Column is used for the Axis. Can be used with one or more aggregations when both Rows and Columns are used for the Axes.
234
235 [[image:Column Combination Scrolling.png||height="408" width="720"]]
236
237 === Column (Combination Dual Y Axis) ===
238
239 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
240 **Aggregations** – Can be used with two or more aggregations. Aggregations are assigned to each axis automatically. This can be overridden by manually adjusting which aggregation plots against each axis.
241
242 [[image:Combi Dual Y.png||height="419" width="720"]]
243
244 === Column (Combination Scrolling Dual Y Axis) ===
245
246 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
247 **Aggregations** – Can be used with two or more aggregations. Aggregations are assigned to each axis automatically. This can be overridden by manually adjusting which aggregation plots against each axis.
248
249 [[image:Combi Scroll Dual Y.png||height="418" width="720"]]
250
251 === Column (Grouped) ===
252
253 **Axes Requirements** – Will render chart against either two Rows or two Columns.
254 **Aggregations** – Will only work with a single aggregation.
255
256 [[image:Screenshot 2021-05-04 at 15.12.22.png||height="654" width="720"]]
257
258
259 === Marimekko (Multi-Series) ===
260
261 **Axes Requirements** – Primarily used by plotting Rows and Columns. It will render the Rows on the axis and the Column stacked against each Row value by default. To render the Columns as the axis, use the Switch Chart Axes option.
262 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
263
264 [[image:Marimekko.png||height="412" width="720"]]
265
266 == Line Graphs ==
267
268 === Line ===
269
270 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
271 **Aggregations** – Choose to display one or more aggregations.
272
273 [[image:Line.png||height="395" width="720"]]
274
275 === Line (Multi-Series) ===
276
277 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
278 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
279
280 [[image:Line Multi.png||height="397" width="720"]]
281
282 === Line (Scrolling) ===
283
284 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
285 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
286
287 [[image:Line Scrolling.png||height="413" width="720"]]
288
289 === Line (Zoom) ===
290
291 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
292 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
293
294 [[image:zoom.png||height="407" width="720"]]
295
296 === Line (Multi-Axis) ===
297
298 **Axes Requirements** – Can only be used with rows.
299 **Aggregations** – Can be used with two or more aggregations. Axes will display on the left by default. Choose left or right axis display for each aggregation.
300
301 [[image:line multi axis.png||height="401" width="720"]]
302
303 === SPC Chart ===
304
305 **Axes Requirements** – Can only be used with Rows.
306 **Aggregations** – Can be used with only one aggregation.
307
308 The chart will render the selected aggregation os the main line on the chart and then automatically calculate and render the average, upper control limit and lower control limit.
309
310 [[image:SPC.png||height="411" width="720"]]
311
312 === Spline ===
313
314 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option.
315 **Aggregations** – Choose to display one or more aggregations.
316
317 [[image:Spline.png||height="407" width="720"]]
318
319 === Spline (Multi-Series) ===
320
321 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Columns by default. To render the Rows, use the Switch Chart Axes option. Choose values in a single axis to chart against multiple aggregations or use both Rows and Columns to chart against a single aggregation.
322 **Aggregations** – Choose a single aggregation when using Rows and Columns. Choose multiple aggregations if choosing just Rows or just Columns.
323
324 [[image:spline multi.png||height="404" width="720"]]
325
326 === Pareto ===
327
328 **Axes** – Will render the chart against either Rows or Columns (but not both).
329 **Aggregations** – Will only work with a single aggregation.
330
331 [[image:Pareto.png||height="417" width="720"]]
332
333 === Pareto 3D ===
334
335 **Axes** – Will render the chart against either Rows or Columns (but not both).
336 **Aggregations** – Will only work with a single aggregation.
337
338 [[image:Pareto 3D.png||height="399" width="720"]]
339
340 == Pie Charts ==
341
342 === Doughnut ===
343
344 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
345 **Aggregations** – Will only work with a single aggregation.
346
347 [[image:donut.png||height="539" width="720"]]
348
349 **Advanced Options**
350 When a Doughnut chart has been specified, two additional caption options become available. Use the **Default** **Caption** text box to add text to the centre of the doughnut, and use the **Hover** **Caption** radio buttons to add text that is displayed when the cursor rolls over a section of the chart. The hover text can be a hard coded value, a variable or a combination of both. The following variables are supported:
351
352 **$value** - outputs the formatted value
353
354 **$label** - outputs the label value
355
356 **$percentValue** - outputs the value as a %
357
358 The Doughnut Chart can also be rendered with sections being separated from the main doughnut using **Exploded Sections**. This is allowed by default and just needs one or more of the segments selected.
359
360 Use the **Starting Angle** to change the position of the segments.
361
362 === Doughnut 3D ===
363
364 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
365 **Aggregations** – Will only work with a single aggregation.
366
367 [[image:donut3d.png||height="391" width="720"]]
368
369 **Advanced Options**
370 Note: the **Default Caption** and **Hover Caption** are not supported for the 3D Doughnut chart.
371
372 The Doughnut Chart can also be rendered with sections being separated from the main doughnut using **Exploded Sections**. This is allowed by default and just needs one or more of the segments selected.
373
374 Use the **Starting Angle** to change the position of the segments.
375
376 === Pie (Exploded) ===
377
378 **Axes** – Will render the chart against either Rows or Columns (but not both).
379 **Aggregations** – Will only work with a single aggregation.
380
381 [[image:ex-pie.png||height="532" width="720"]]
382
383 === Pie (Multi-Level) ===
384
385 **Axes Requirements** – Will render chart against either nested Rows or nested Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
386 **Aggregations** – Will only work with a single aggregation.
387
388 [[image:pie-multi.png||height="705" width="720"]]
389
390 === Pie ===
391
392 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
393 **Aggregations** – Will only work with a single aggregation.
394
395 [[image:pie.png||height="543" width="720"]]
396
397 **Advanced Options**
398
399 The Pie Chart can also be rendered with sections being separated from the main pie using **Exploded Sections**. This is allowed by default and just needs one or more of the segments selected.
400
401 Use the **Starting Angle** to change the position of the segments.
402
403 === Pie 3D ===
404
405 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
406 **Aggregations** – Will only work with a single aggregation.
407
408 [[image:Pie 3D.png||height="313" width="720"]]
409
410 **Advanced Options**
411
412 The Pie Chart can also be rendered with sections being separated from the main pie using **Exploded Sections**. This is allowed by default and just needs one or more of the segments selected.
413
414 Use the **Starting Angle** to change the position of the segments.
415
416 === Radial Chart ===
417
418 **Axes Requirements** – Will only render chart against Rows.
419 **Aggregations** – Will only work with a single aggregation.
420
421 [[image:radial.png||height="230" width="720"]]
422
423 To increase the spacing between radials or their labels, click **Advanced Options** within the charting tab. The number of pixels separating these elements can then be specified using the **Chart Paddings** options.
424
425 === Radial Picture Chart ===
426
427 **Axes Requirements** – Will only render chart against Rows.
428 **Aggregations** – Will only work with a single aggregation.
429
430 Upload SVG files to use in the chart using the import option. Please refer to the [[Importing and Exporting>>doc:Technical Documentation.CXAIR.User Guide.4\. Importing and Exporting.WebHome]] chapter for more information.
431
432 [[image:radial picture.png||height="261" width="720"]]
433
434 === Radial Multi Chart ===
435
436 **Axes Requirements** – Will only render chart against Rows.
437 **Aggregations** – Will only work with a single aggregation.
438
439 [[image:rad multi.png||height="663" width="720"]]
440
441 == XY ==
442
443 === Bubble Chart Nested ===
444
445 **Axes Requirements** – Will render chart against either Rows or Columns but not both. Best results only work with 2 nested levels or Rows or Columns.
446 **Aggregations** – Will only work with a single aggregation.
447
448 [[image:bubble nested.png||height="728" width="720"]]
449
450 === Node Link ===
451
452 **Axes Requirements** – Will only render chart against Rows.
453 **Aggregations** – Will only work with a single aggregation.
454
455 [[image:node.png||height="698" width="720"]]
456
457 === Tree ===
458
459 **Axes Requirements** – Will only render chart against Rows.
460 **Aggregations** – Will only work with a single aggregation.
461
462 [[image:tree.png||height="750" width="720"]]
463
464 Click the coloured nodes to expand the tree based on the selected rows.
465
466 === Tree Map ===
467
468 **Axes Requirements** – Will render chart against Rows or Columns (but not both). Nested fields will create more tree segments
469 **Aggregations** – Will only work with two aggregations.
470
471 [[image:tree map.png||height="630" width="720"]]
472
473 Click a value on the chart to zoom in on all associated values based on the selected rows.
474
475 == Miscellaneous Charts ==
476
477 === Candlestick ===
478
479 **Axes Requirements** – Will only render chart against Rows.
480 **Aggregations** – Will only work with five aggregations (Min, Max, Lower Quartile, Upper Quartile and Volume).
481
482 **Pallette **- Will only render correctly using the 'Fusion' Pallette.
483
484 [[image:candle.png||height="420" width="720"]]
485
486 === Sankey Diagram ===
487
488 **Axes Requirements** – Will only render chart against Rows and Columns.
489 **Aggregations** – Will only work with a single aggregation.
490
491 [[image:sankey.png||height="422" width="720"]]
492
493 === Heat Map ===
494
495 **Axes Requirements** – Will only render chart against Rows and Columns.
496 **Aggregations** – Will only work with a single aggregation.
497
498 [[image:heat.png||height="409" width="720"]]
499
500 === Chord ===
501
502 **Axes Requirements** – Will only render chart against Rows and Columns.
503 **Aggregations** – Will only work with a single aggregation.
504
505 [[image:chord.png||height="686" width="720"]]
506
507 === Gantt ===
508
509 **Axes Requirements** – Will only render against rows in the following format: Name, Start Date, End Date, Percentage Complete (Optional).
510 **Aggregations** – Will only work with a single aggregation.
511
512 [[image:Gantt Chart ProjectCompletionStatus.png||height="388" width="720"]]
513
514 === Kagi ===
515
516 **Axes Requirements** – Will only render chart against Rows and Columns.
517 **Aggregations** – Will only work with a single aggregation.
518
519 [[image:kagi.png||height="411" width="720"]]
520
521 === SPC Chart - CStatus ===
522
523 **Axes Requirements** – Will only render chart against Rows.
524 **Aggregations** – Will only work with a single aggregation.
525
526 The default Shift Size is set to 1. If the Shift Size needs changing this can be found in the Advanced Settings under Charting.
527
528 [[image:spc c status.png||height="425" width="720"]]
529
530 === SPC Chart - Individual ===
531
532 **Axes Requirements** – Will only render chart against Rows.
533 **Aggregations** – Will only work with a single aggregation.
534
535 [[image:spc individual.png||height="413" width="720"]]
536
537 === SPC Chart - Moving Range ===
538
539 **Axes Requirements** – Will only render chart against Rows.
540 **Aggregations** – Will only work with a single aggregation.
541
542 [[image:spc moving range.png||height="418" width="720"]]
543
544 === SPC Chart - X bar ===
545
546 **Axes Requirements** – Will only render chart against Rows.
547 **Aggregations** – Works best against more than one aggregation as the Mean is created across all aggregations for each axis point.
548
549 By default, the 1st aggregation in the list will be used as the Mean Label. This can be overridden in Advanced Options under Charting
550
551 [[image:x-bar.png||height="413" width="720"]]
552
553 === SPC Chart - Cumulative Sum ===
554
555 **Axes Requirements** – Will only render chart against Rows.
556 **Aggregations** – Will only work with a single aggregation.
557
558 The default Shift Size is set to 1. If the Shift Size needs changing this can be found in the Advanced Settings under Charting.
559
560 [[image:cumulativesum.png||height="409" width="720"]]
561
562 === SPC Chart - X bar Moving Range ===
563
564 **Axes Requirements** – Can be used with a single row.
565 **Aggregations** – Works best against more than one aggregation as the Range is created from the Min and Max of the aggregations for each Axis point.
566
567 [[image:m-range.png||height="405" width="720"]]
568
569 === Funnel ===
570
571 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
572 **Aggregations** – Will only work with a single aggregation.
573
574 [[image:funnel.png||height="389" width="720"]]
575
576 === Bullet ===
577
578 **Axes Requirements** – Will only render chart against Rows.
579 **Aggregations** – Will only work with three or more aggregations.
580
581 Assign each aggregation to the Range, Measure and Marker(s). Multiple ranges and Measures can be used but they render overlapped.
582
583 [[image:bullet.png||height="388" width="720"]]
584
585 === Bullet - Vertical ===
586
587 **Axes Requirements** – Will only render chart against Rows.
588 **Aggregations** – Will only work with three or more aggregations.
589
590 Assign each aggregation to the Range, Measure and Marker(s). Multiple ranges and Measures can be used but they render overlapped.
591
592 [[image:v bullet.png||height="395" width="720"]]
593
594 === Pyramid 3D ===
595
596 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
597 **Aggregations** – Will only work with a single aggregation.
598
599 [[image:pyramid.png||height="398" width="720"]]
600
601 === Radar ===
602
603 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
604 **Aggregations** – Choose to display one or more aggregations.
605
606 [[image:radar.png||height="499" width="720"]]
607
608 === Spark Column ===
609
610 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
611 **Aggregations** – Will only work with a single aggregation.
612
613 [[image:Spark Column.png||height="394" width="720"]]
614
615 === Spark Column Multi Chart ===
616
617 **Axes** – Will render chart against Rows and Columns. It will render the Rows as the series by default. To render the Columns as the series, use the Switch Chart Axes option.
618 **Aggregations** – Will only work with a single aggregation.
619
620 [[image:spark column multi.png||height="422" width="720"]]
621
622 === Spark Line ===
623
624 **Axes** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
625 **Aggregations** – Will only work with a single aggregation.
626
627 [[image:spark line.png||height="308" width="720"]]
628
629 === Spark Line Multi Chart ===
630
631 **Axes** – Will render chart against Rows and Columns. It will render the Rows as the series by default. To render the Columns as the series, use the Switch Chart Axes option.
632 **Aggregations** – Will only work with a single aggregation.
633
634 [[image:spark line multi.png||height="423" width="720"]]
635
636 === Time ===
637
638 **Axes Requirements** – Can be used with rows and columns as axes. A date field must be selected as the Row or the chart will not render.
639 **Aggregations** – Will work with one or more aggregations.
640 **Advanced Options** – **Plot Nulls As Zero** prevents null values will plot any null date value on the chart rather than extending the line to the next non-null plot point. The navigation slider can be hidden using the **Show Navigator** checkbox. The default Time chart will render using lines but this can be changed using the **Plot Type** drop list. Other render options are Column, Area, Smooth Area, Spline and Step Line.
641
642 [[image:time.png||height="590" width="720"]]
643
644 === Picture Chart ===
645
646 **Axes Requirements** – Will only render chart against Rows.
647 **Aggregations** – Will only work with a single aggregation.
648
649 [[image:Picture.png||height="255" width="720"]]
650
651 === Bubble Chart ===
652
653 **Axes Requirements** – Will render chart against either Rows, Columns or Rows and Columns.
654 **Aggregations** – Will only work with three or more aggregations.
655
656 Use **Quadrants** in Advanced Options under Charting to provide better clarity on analysis.
657
658 [[image:bubble.png||height="678" width="720"]]
659
660
661 === Box and Whiskers ===
662
663 **Axes Requirements** – Will render chart against either Rows or Columns. If the Crosstab contains both Rows and Columns, it will render the Rows by default. To render the Columns, use the Switch Chart Axes option.
664 **Aggregations** – Will work with one or more aggregations.
665
666 Please note that the charting output will only provide meaningful output on a single total if rows and columns have been specified and the **Total Type** has been set to **Count**.
667
668 Alternatively, the five totals plotted by the chart can be manually created and must be in the following order: **maximum**, **upper quartile**, **median**, **lower quartile** and **minimum**.
669
670 [[image:b+w.png||height="420" width="720"]]
671
672 = Chart Options =
673
674 To control where the chart will display, select an option from the **Position** drop-down list. Change the size using the **Width** and **Height** textboxes to enter the required size in pixels. Change the default axis labels by using the **X Axis Label** and **Y Axis Label** textboxes.
675
676 The **Chart Columns** option will reverse the axis being charted. Enable and disable the chart animation with the **Show Animation** checkbox and add a gradient to the colour of a chart using the **Show Gradient** checkbox.
677
678 Toggle the representation of thousands as ‘K’ and millions as ‘M’ with the **Format Number Scale** checkbox. The **Show Axis Labels** checkbox controls whether axis labels are displayed while the **Show Values** checkbox controls whether values are displayed. Disable the **Show Y Axis Values** to hide these values on the chart. Check the **Inside** checkbox to display values inside the bars of a bar chart, if unticked they will appear above. Check the **Rotate** checkbox to display values vertically, if unticked they will appear horizontally.
679
680 Use the **Select Aggregation** drop-down list to choose the aggregations that will be charted. To remove, click the **X** icon next to the relevant aggregation. The **Use Totals As Axis** option becomes available when using a multi-series chart type and more than one aggregation and allows the use of aggregations as the axis labels.
681
682 When using line or spline charts, the **Line Weight** textbox specifies the thickness of chart lines, with a higher number producing thicker lines.
683
684 The **Legend Position** drop-down list allows the repositioning of the chart legend while the **Show Legend Border** can be used to hide or display the box that surround the legend. By checking the **Reverse Legend** option, the legend values will be displayed in reverse alphabetical order. Enter the required text in the **Legend Caption** textbox to add it at the top of the legend. Enable the **Hide Legend Caption** option to disable the entered caption rather than deleting it from the textbox, allowing it to be quickly re-enabled once required.
685
686 With the **Colours** drop-down list, a predefined colour scheme theme can be applied to the chart. The **Default Colours** radio button will use the predefined colours while the **Specify Colours** radio button will allow a colour choice for each aggregation in the chart by typing in the hex code or selecting a colour from the pop-up box. Delete colours with the relevant **X** icon.
687
688 When configuring line charts, click the **Dashed** checkbox next to the corresponding aggregation to display lines as dashes.
689
690 Click the **All Same Colour** radio button to display aggregations without colour differentiation and click the **Gradient** radio button to apply a colour gradient to all aggregations. To alter the spaces between bars in a bar chart, type a value in the **Plot Space Percent** textbox. The larger the value, the wider the space between values.
691
692 == Advanced Options ==
693
694 Click **Advanced Options** to further configure the chart.
695
696 To add a background image, click the **Select Image** option under the **Background Image** heading to open the load dialog. Click the checkbox adjacent to the required image to load it into the report. Please note that Internet Explorer 11 cannot display chart backgrounds.
697
698 Set the minimum and maximum displayed axis values using the **Axis Scale** textboxes. This allows a consistent display when comparing multiple charts.
699
700 Enable the **Enhanced Tooltip** option to present an expanded text box where a number of options are available. Please note that when adding Enhanced Tooltips to Crosstab reports, this functionality is reduced to exclude saved reports or totals. When users hover over the added component, the enhanced tooltip is displayed.
701
702 === Trends ===
703
704 It is possible to add one or more trendlines or zones to a chart. First, click **New Trend**. Enter a value into the first and second textboxes to specify the range and label the trend using the **Name** textbox.
705
706 Change the trend **Colour** by typing in the hex code or by selecting a colour from the pop-up box and use the **Opacity** slider to customise how prominently the trend will appear over the chart. Use the **Zone** checkbox to toggle between a trend line or trend zone.
707
708 If using a trendline, type a value in the **Thickness** textbox to edit the width of resulting line. Check the **Value on Right** checkbox to display text entered in the **Name** textbox to the right of the trend to avoid obscuring axis values. To created a dashed trendline, enable the **Dashed** option.
709
710 When a colour palette is configured, charts will automatically adopt the palette when the fields specified in the palette are present in the [[Crosstab>>doc:Technical Documentation.CXAIR.User Guide.02\. Reporting.2c\. Crosstabs.WebHome]].
711
712 = Styling Options =
713
714 For further styling options, click the chart preview at the bottom of the screen and select the relevant area from the subsequent popup menu.
715
716 Select **Chart** to style the entire chart, where the theme can be selected from the **Colours** drop-down list modified using the **Default Colours**, **Specify Colours**, **All Same Colour** and **Gradient** radio buttons.
717
718 The **Font** and **Font Size** are controlled using their own drop-down lists, and the **Style** checkboxes allow further customisation of displayed values. Change the **Text Colour** and **Background Colour** by either typing in the hex code or by selecting a colour from the pop-up colour picker.
719
720 Use the **X-Axis Label Font Size** and **Y-Axis Label Font Size** drop-down lists to control each axis label separately. The chart legend values and caption values are controlled by the **Legend Font Size** and **Legend Caption Font Size**, respectively. Change the **Legend Colour** by either typing in the hex code or by selecting a colour from the pop-up colour picker.
721
722 Enable the **Show Values** option to display underlying values as part of the chart. Enable the **Inside** option to display these values inside the columns.
723
724 Enable the **Show Labels** option to output axis labels. Once enabled, three radio button options are available to control the orientation. Select **Automatic** to detect the best option based on character length, or select between **90°** and **45°** to manually set the angle.
725
726 When **Chart Values** is selected from the preview popup menu, use the **Background Opacity** slider to modify the visibility of the specified **Background Colour**.