Table Chart 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.
...
| Parameter | Parameter Name | Default | Description |
|---|
| tfc-width | Width | | Width of the chart in pixels. |
|---|
| tfc-height | Height | | Height of the chart in pixels. |
|---|
| column | Row labels / Dates column | | Name of the column containing data labels or dates. |
|---|
| datepattern | Date format | | Format of dates used in the table. |
|---|
| aggregation | Values column | | Name of the column containing data values. |
|---|
| id | ID | Assigned automatically | ID of the chart. |
|---|
| type | Type | | Type of the chart to generate. |
|---|
| separator | Decimal Separator | | Decimal separator used in data values. |
|---|
| hide | Hide the source table | Disabled | Option to hide the source table with data. |
|---|
| hidecontrols | Hide controls | DIsabledDisabled | Option to hide the controls used to manage parameters of the Table Chart macro. |
|---|
...
| Chart from Table |
|---|
| tfc-width | 800 |
|---|
| tfc-height | 250 |
|---|
| column | Income‚Balance‚Spendings |
|---|
| datepattern | m/d/yy |
|---|
| aggregation | Date |
|---|
| id | 1441010024413_-1416480034 |
|---|
| type | Time Line |
|---|
| separator | Point (.) |
|---|
|
| 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
| Chart from Table |
|---|
| tfc-width | |
|---|
| tfc-height | |
|---|
| column | Awesome Graphs |
|---|
| datepattern | yy-mm-dd |
|---|
| aggregation | |
|---|
| id | 1449569330039_0 |
|---|
| type | Pie |
|---|
| separator | Point (.) |
|---|
|
| Sales | Table Filter | Smart Attachments | Awesome Graphs | Quizzes | Customer Case | | Q1 2014 | 177 | 72 | 250 | 50 | 19 | | Q2 2014 | 195 | 72 | 107 | 26 | 24 | | Q3 2014 | 122 | 83 | 190 | 33 | 25 | | Q4 2014 | 123 | 94 | 105 | 48 | 12 | | Q1 2015 | 167 | 91 | 111 | 44 | 16 | | Q2 2015 | 100 | 50 | 245 | 44 | 14 | | Q3 2015 | 166 | 96 | 153 | 42 | 22 | | Q4 2015 | 124 | 78 | 142 | 20 | 20 |
|