Versions Compared

Old Version 23

changes.mady.by.user StiltSoft

Saved on

compared with

New Version Current

changes.mady.by.user StiltSoft

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Table of Contents
maxLevel3
minLevel2

Adding Simple Smart Charts

Hover over the table, click the Image Added icon on the top right corner of the table and select the Image Added option.

Select the chart type, select one of the charts suggested. To remove the chart, click the Image Added icon and select the Remove the macro option.

Try to build a chart based on the sample table below.

Expand
titleSee how to insert and remove a chart...

Image Added

AgentDateTickets per HourTicket Response (min)Calls per HourAnswered TIckets
Remy Dempo25.06.20207.33.23.389
Rahul Dickstein26.06.20208.53.11.895
Radu Donahue27.06.20205.03.74.565
Preston Doorey28.06.20202.25.82.728
Phill Doyle29.06.20203.95.22.937

Chart Examples

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

Table of Contents
minLevel3

Sample Chart #1 - Pie/Donut, Column, Bar

Info
titleUse 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 Image Removedicon Image Added 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.

Chart from Table
tfc-width700
columnAgent
aggregationAnswered TIckets
is3d
typePie
separatorPoint (.)
version2
colors#8eb021,#d04437,#3572b0,#f6c342,#654982
hidetrue
tfc-height350columnAgent
datepatterndd.mm.yy
pieKeysRemy Dempo‚Rahul Dickstein‚Radu Donahue‚Preston Doorey‚Phill DoyleaggregationAnswered TIckets
id1438704803153_646027804
typePie
separatorPoint (.)
AgentDateTickets per HourTicket Response (min)Calls per HourAnswered TIckets
Remy Dempo25.06.201520207.33.23.389
Rahul Dickstein26.06.201520208.53.11.895
Radu Donahue27.06.201520205.03.74.565
Preston Doorey28.06.201520202.25.82.728
Phill Doyle29.06.201520203.95.22.937

Sample Chart #2 - Line/Area

Info
titleUse 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 Image Removed Image Added 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.

Chart from Table
tfc-width700
hidetrue
tfc-height250
columnSpendings
datepatternm/d/yy
aggregationIncome‚Balance
id1441007490232_-1416480034
typeLine
separatorPoint (.)
version2
DateIncomeSpendingsBalance
8/1/201520214366.504332.4334.07
8/2/201520213369.004251.00-882.00
8/3/201520214685.005212.57-527.57
8/4/201520213284.252912.14372.11
8/5/201520212892.754260.00-1367.25
8/6/201520212833.383034.29-200.91
8/7/201520213827.634318.00-490.38
8/8/201520213936.385706.71-1770.34
8/9/201520214804.383199.571604.80
8/10/201520214325.384151.86173.52
8/11/201520214884.133800.711083.41
8/12/201520214265.383469.86795.52
8/13/201520214737.253301.141436.11
8/14/201520213201.754026.86-825.11
8/15/201520214498.884910.00-411.13
8/16/201520214823.883562.861261.02
8/17/201520213833.634584.57-750.95
8/18/201520212753.252933.71-180.46
8/19/201520213685.254079.57-394.32
8/20/201520214313.504852.71-539.21
8/21/201520212726.255172.00-2445.75
8/22/201520214849.254364.57484.68
8/23/201520213778.505115.14-1336.64
8/24/201520213225.503665.71-440.21
8/25/201520214719.133601.571117.55
8/26/201520213815.253517.00298.25
8/27/201520214983.883913.861070.02
8/28/201520214219.005315.14-1096.14
8/29/201520213282.005555.86-2273.86
8/30/201520213746.133921.57-175.45
8/31/201520214939.504909.2930.21

Sample Chart #3 - Time Line/Area

Info
titleUse 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 Image Removed Image Added 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.

You can display the trendlines to better understand data movements over the entire time period.

Chart from Table
tfc-width800
hidedataorientationtrueVertical
tfc-heightlegend250right
columnDatedatepatternm/d/yy
aggregationIncome‚Balance‚Spendings
alignCenterid1441010024413_-1416480034
typeTime Line
separatorPoint (.)
version2
colors#8eb021,#d04437,#3572b0
hidetrue
tfc-height250
trendlinetrue
datepatternm/d/yy
id1513330652085_1371528485
worklog5|8|w d h m
DateIncomeSpendingsBalance
8/1/201520214366.504332.4334.07
8/2/201520213369.004251.00-882.00
8/3/201520214685.005212.57-527.57
8/4/201520213284.252912.14372.11
8/5/201520212892.754260.00-1367.25
8/6/201520212833.383034.29-200.91
8/7/201520213827.634318.00-490.38
8/8/201520213936.385706.71-1770.34
8/9/201520214804.383199.571604.80
8/10/201520214325.384151.86173.52
8/11/201520214884.133800.711083.41
8/12/201520214265.383469.86795.52
8/13/201520214737.253301.141436.11
8/14/201520213201.754026.86-825.11
8/15/201520214498.884910.00-411.13
8/16/201520214823.883562.861261.02
8/17/201520213833.634584.57-750.95
8/18/201520212753.252933.71-180.46
8/19/201520213685.254079.57-394.32
8/20/201520214313.504852.71-539.21
8/21/201520212726.255172.00-2445.75
8/22/201520214849.254364.57484.68
8/23/201520213778.505115.14-1336.64
8/24/201520213225.503665.71-440.21
8/25/201520214719.133601.571117.55
8/26/201520213815.253517.00298.25
8/27/201520214983.883913.861070.02
8/28/201520214219.005315.14-1096.14
8/29/201520213282.005555.86-2273.86
8/30/201520213746.133921.57-175.45
8/31/201520214939.504909.2930.21

Sample Chart #4 - Stacked Column/Bar

Info
titleUse Hint

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

  • Q1 20142020
  • Q2 20142020
  • Q3 20142020
  • Q4 20142020
  • Q1 20152021
  • Q2 20152021
  • Q3 20152021
  • Q4 20152021

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

  • Stacked Column
  • Stacked Bar

You can use the Cogwheel Image Removed Image Added 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.

Chart from Table
tfc-width500
hidetrue
tfc-height400
columnAdd-on
datepatternyy-mm-dd
aggregationQ1 2014‚Q2 2014‚Q3 2014‚Q4 2014
id1449569397567_-127502783
typeStacked Column
separatorPoint (.)
version2
Add-onQ1 20142020Q2 20142020Q3 20142020Q4 20142020Q1 20152021Q2 20152021Q3 20152021Q4 20152021
Table Filter139114145106106103148105
Smart Attachments5479696690965097
Awesome Graphs142128135195198179238192
Quizzes2048364233374629
Customer Case1510132518221719

Sample Chart #5 - Gantt

Info
titleUse Hint

You can build a Gantt chart to visualize project stages during the project planning and resource estimation.

Chart from Table
is3d
dataorientationVertical
legendright
columnTask Type‚Task Description‚Milestone‚Event
aggregationStart Date‚End Date‚Completion‚Date
falsealignCenter
typeGantt
separatorPoint (.)
version2
colors#8eb021,#d8d23a#7b6888,#69a6f9,#d04437,#0c6197,#a3acb2,#3572b0,#cc1010,#31383b,#f6c342,#e98125,#6ada6a,#654982,#e4a14b,#8cc3e9,#d8d23a,#65a620,#d8d23a,#f691b2,#2484c1
hidefalsetrue
datepatternm/d/yy
pieKeysAnalysis‚Analysis - Done‚Analysis - Todo‚Design‚Design - Done‚Design - Todo‚Development‚Development - Done‚Development - Todo‚Testing‚Testing - Done‚Testing - Todo‚Deployment‚Deployment - Done‚Deployment - Todo‚Today‚Meeting Todo‚RC1‚RC2‚Today‚Meeting with Stakeholders‚Payment
id1513330486549_-1286331324
worklog7|10|h
Task TypeTask DescriptionStart DateEnd DateCompletion
AnalysisOnsite Meetings8/1/
2017
20208/7/
2017
2020100%
AnalysisDiscussions with Stakeholders8/8/
2017
20208/20/
2017
2020100%
Analysis

Documenting Requirements

8/15/
2017
20208/25/
2017
202095%
AnalysisCreation of Mockups8/
20
21/
2017
20209/7/
2017
202095%
AnalysisVerification of Requirements9/5/
2017
20209/15/
2017
202050%
DesignDesign Database9/15/
2017
20209/25/
2017
20200%
DesignSoftware Design9/
25
26/
2017
202010/1/
2017
20200%
DesignInterface Design10/5/
2017
202010/15/
2017
20200%
DesignCreate Design Specifications10/17/
2017
202010/25/
2017
20200%
DesignVerification of Design Specifications10/28/
2017
202011/7/
2017
20200%
DevelopmentDevelopment of System Modules10/
15
16/
2017
202012/31/
2017
20200%
Development

Integration of System Modules

1/1/
2018
20211/15/
2018
20210%
DevelopmentInitial Testing of System Modules1/
15
17/
2018
20211/31/
2018
20210%
DevelopmentDeployment to Test Environment2/1/
2018
20212/5/
2018
20210%
TestingSystem Testing1/20/
2018
20212/8/
2018
20210%
TestingPenetration Testing2/10/
2018
20212/15/
2018
20210%
TestingPerformance Testing2/17/
2018
20212/20/
2018
20210%
TestingTracking Found Issues2/18/
2018
20212/25/
2018
20210%
TestingFixing Found Issues2/
20
21/
2018
20212/28/
2018
20210%
DeploymentData Migration3/1/
2018
20213/4/
2018
20210%
DeploymentSystem Integration3/5/
2018
20213/9/
2018
20210%
DeploymentSystem Monitoring3/10/
2018
20213/31/
2018
20210%
Task TypeMilestoneDate
DevelopmentRC1

1/25/

2018

2021

DevelopmentRC22/3/
2018
2021

Event

Date

Todaytoday
Meeting with Stakeholders
12
10/5/
2017
2020
Payment3/15/
2018
2021