Chart from Table is a macro bundled within Table Filter and Charts add-on. It allows you to generate dynamically updated charts with a capability to instantly switch between columns with different data values.

Parameters

The add-on adds the Chart from Table macro. You can add this macro onto your Confluence page and further paste any table into the macro body. You can also insert the macros that generate the table data and get a dynamic chart at once. The following parameters are available to you:

Parameter	Parameter Name	Default	Description
id	ID	Assigned automatically	ID of the chart.
column	Labels Column	None	The column containing labels for data values.
aggregation	Values column	None	The column containing numerical values for chart generation.
column	X-axis value column	None	The column containing numerical values for chart generation.
aggregation	Y-axis value column	None	The column or columns containing numerical values for chart generation.
column	Dates column	None	You can select the column with dates for chart generation.
datepattern	Date Format	yy-mm-dd	You can specify the date format used in the column with dates.
type	Type	Pie	You can select the appropriate chart type.
separator	Decimal Separator	Point	You can select the decimal separator (either point or comma).
tfc-height	Height	None (dependable on screen area)	You can define the height of the generated chart.
tfc-width	Width	None (dependable on screen area)	You can define the width of the generated chart.
hide	Hide the source table	Disabled	You can hide the table with data and enable display of the chart only.
hidecontrols	Hide chart controls	Disabled	You can hide the chart controls when you need just to display the chart without a necessity to update its view.
dataorientation	Table data orientation	Vertical	You can select the appropriate orientation of your table data for chart generation.
legend	Show legend	Enabled	You can hide the legend for the generated chart.
grid	Show grid	Enabled	You can enabled display of the grid on the generated chart.
title	Chart Title	Disabled	You can specify the title of the chart.
align	Align chart	Enabled	You can define the appropriate alignment for the chart.
xtitle	X-axis label	None	You can specify the label for X axis of the chart.
ytitle	Y-axis label	None	You can specify the label for Y axis of the chart.
minvalue	Minimal Value	None	You can specify the minimal value for showing only data values greater than the specified minimal value.
maxvalue	Maximal Value	None	You can specify the maximal value for showing only data values not greater than the specified maximal value.
scalestep	Scale Step	None	You can specify the required scale step for showing the chart.
xminvalue	Minimal X Value	None	You can specify the minimal value for X axis for showing only data values greater than the specified minimal value.
xmaxvalue	Maximal X Value	None	You can specify the maximal value for X axis for showing only data values not greater than the specified maximal value.
minvalue	Minimal Y Value	None	You can specify the minimal value for Y axis for showing only data values greater than the specified minimal value.
maxvalue	Maximal Y Value	None	You can specify the maximal value for Y axis for showing only data values not greater than the specified maximal value.
xscalestep	Scale X Step	None	You can specify the required scale step of X axis for showing the chart.
scalestep	Scale Y Step	None	You can specify the required scale step of Y axis for showing the chart.

Chart Examples

Try to see Chart from Table macro in action while working with the following chart examples.

Sample Chart #1

Use Hint

Try to alternate the view of the chart by switching among the following chart types:

Pie
Donut
3D Donut
Column
Bar

You can also select a new column with data values of the following ones:

Answered Tickets
Call per Hour
Ticket Response (min)
Tickets per Hour

You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.

700350Agentdd.mm.yyAnswered TIckets1438704803153_646027804PiePoint (.)

Agent	Date	Tickets per Hour	Ticket Response (min)	Calls per Hour	Answered TIckets
Remy Dempo	25.06.2015	7.3	3.2	3.3	89
Rahul Dickstein	26.06.2015	8.5	3.1	1.8	95
Radu Donahue	27.06.2015	5.0	3.7	4.5	65
Preston Doorey	28.06.2015	2.2	5.8	2.7	28
Phill Doyle	29.06.2015	3.9	5.2	2.9	37

Sample Chart #2

Use Hint

Try to alternate the view of the chart by switching among the following chart types:

Line
Area

For the Row Labels and Values Column use only table columns containing numbers.

You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.

700true250Spendingsm/d/yyIncome‚Balance1441007490232_-1416480034LinePoint (.)2

Date	Income	Spendings	Balance
8/1/2015	4366.50	4332.43	34.07
8/2/2015	3369.00	4251.00	-882.00
8/3/2015	4685.00	5212.57	-527.57
8/4/2015	3284.25	2912.14	372.11
8/5/2015	2892.75	4260.00	-1367.25
8/6/2015	2833.38	3034.29	-200.91
8/7/2015	3827.63	4318.00	-490.38
8/8/2015	3936.38	5706.71	-1770.34
8/9/2015	4804.38	3199.57	1604.80
8/10/2015	4325.38	4151.86	173.52
8/11/2015	4884.13	3800.71	1083.41
8/12/2015	4265.38	3469.86	795.52
8/13/2015	4737.25	3301.14	1436.11
8/14/2015	3201.75	4026.86	-825.11
8/15/2015	4498.88	4910.00	-411.13
8/16/2015	4823.88	3562.86	1261.02
8/17/2015	3833.63	4584.57	-750.95
8/18/2015	2753.25	2933.71	-180.46
8/19/2015	3685.25	4079.57	-394.32
8/20/2015	4313.50	4852.71	-539.21
8/21/2015	2726.25	5172.00	-2445.75
8/22/2015	4849.25	4364.57	484.68
8/23/2015	3778.50	5115.14	-1336.64
8/24/2015	3225.50	3665.71	-440.21
8/25/2015	4719.13	3601.57	1117.55
8/26/2015	3815.25	3517.00	298.25
8/27/2015	4983.88	3913.86	1070.02
8/28/2015	4219.00	5315.14	-1096.14
8/29/2015	3282.00	5555.86	-2273.86
8/30/2015	3746.13	3921.57	-175.45
8/31/2015	4939.50	4909.29	30.21

Sample Chart #3

Use Hint

Try to alternate the view of the chart by switching among the following chart types:

Time Line
Time Area

Alternate the Values Column among the following table columns:

Income
Spendings
Balance

You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.

800true250Datem/d/yyIncome‚Balance‚Spendings1441010024413_-1416480034Time LinePoint (.)2

Date	Income	Spendings	Balance
8/1/2015	4366.50	4332.43	34.07
8/2/2015	3369.00	4251.00	-882.00
8/3/2015	4685.00	5212.57	-527.57
8/4/2015	3284.25	2912.14	372.11
8/5/2015	2892.75	4260.00	-1367.25
8/6/2015	2833.38	3034.29	-200.91
8/7/2015	3827.63	4318.00	-490.38
8/8/2015	3936.38	5706.71	-1770.34
8/9/2015	4804.38	3199.57	1604.80
8/10/2015	4325.38	4151.86	173.52
8/11/2015	4884.13	3800.71	1083.41
8/12/2015	4265.38	3469.86	795.52
8/13/2015	4737.25	3301.14	1436.11
8/14/2015	3201.75	4026.86	-825.11
8/15/2015	4498.88	4910.00	-411.13
8/16/2015	4823.88	3562.86	1261.02
8/17/2015	3833.63	4584.57	-750.95
8/18/2015	2753.25	2933.71	-180.46
8/19/2015	3685.25	4079.57	-394.32
8/20/2015	4313.50	4852.71	-539.21
8/21/2015	2726.25	5172.00	-2445.75
8/22/2015	4849.25	4364.57	484.68
8/23/2015	3778.50	5115.14	-1336.64
8/24/2015	3225.50	3665.71	-440.21
8/25/2015	4719.13	3601.57	1117.55
8/26/2015	3815.25	3517.00	298.25
8/27/2015	4983.88	3913.86	1070.02
8/28/2015	4219.00	5315.14	-1096.14
8/29/2015	3282.00	5555.86	-2273.86
8/30/2015	3746.13	3921.57	-175.45
8/31/2015	4939.50	4909.29	30.21

Sample Chart #4

Use Hint

Try to alternate the view of the chart by adding or removing columns with values for this stacked column chart:

Q1 2014
Q2 2014
Q3 2014
Q4 2014
Q1 2015
Q2 2015
Q3 2015
Q4 2015

Alternate the view of the chart by switching between the following chart types:

Stacked Column
Stacked Bar

You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.

500true400Add-onyy-mm-ddQ1 2014‚Q2 2014‚Q3 2014‚Q4 20141449569397567_-127502783Stacked ColumnPoint (.)2

Add-on	Q1 2014	Q2 2014	Q3 2014	Q4 2014	Q1 2015	Q2 2015	Q3 2015	Q4 2015
Table Filter	139	114	145	106	106	103	148	105
Smart Attachments	54	79	69	66	90	96	50	97
Awesome Graphs	142	128	135	195	198	179	238	192
Quizzes	20	48	36	42	33	37	46	29
Customer Case	15	10	13	25	18	22	17	19