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

Adding Simple Smart Charts

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

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

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

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.

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

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.

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

Sample Chart #2 - Line/Area

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.

DateIncomeSpendingsBalance
8/1/20214366.504332.4334.07
8/2/20213369.004251.00-882.00
8/3/20214685.005212.57-527.57
8/4/20213284.252912.14372.11
8/5/20212892.754260.00-1367.25
8/6/20212833.383034.29-200.91
8/7/20213827.634318.00-490.38
8/8/20213936.385706.71-1770.34
8/9/20214804.383199.571604.80
8/10/20214325.384151.86173.52
8/11/20214884.133800.711083.41
8/12/20214265.383469.86795.52
8/13/20214737.253301.141436.11
8/14/20213201.754026.86-825.11
8/15/20214498.884910.00-411.13
8/16/20214823.883562.861261.02
8/17/20213833.634584.57-750.95
8/18/20212753.252933.71-180.46
8/19/20213685.254079.57-394.32
8/20/20214313.504852.71-539.21
8/21/20212726.255172.00-2445.75
8/22/20214849.254364.57484.68
8/23/20213778.505115.14-1336.64
8/24/20213225.503665.71-440.21
8/25/20214719.133601.571117.55
8/26/20213815.253517.00298.25
8/27/20214983.883913.861070.02
8/28/20214219.005315.14-1096.14
8/29/20213282.005555.86-2273.86
8/30/20213746.133921.57-175.45
8/31/20214939.504909.2930.21

Sample Chart #3 - Time Line/Area

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.

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

DateIncomeSpendingsBalance
8/1/20214366.504332.4334.07
8/2/20213369.004251.00-882.00
8/3/20214685.005212.57-527.57
8/4/20213284.252912.14372.11
8/5/20212892.754260.00-1367.25
8/6/20212833.383034.29-200.91
8/7/20213827.634318.00-490.38
8/8/20213936.385706.71-1770.34
8/9/20214804.383199.571604.80
8/10/20214325.384151.86173.52
8/11/20214884.133800.711083.41
8/12/20214265.383469.86795.52
8/13/20214737.253301.141436.11
8/14/20213201.754026.86-825.11
8/15/20214498.884910.00-411.13
8/16/20214823.883562.861261.02
8/17/20213833.634584.57-750.95
8/18/20212753.252933.71-180.46
8/19/20213685.254079.57-394.32
8/20/20214313.504852.71-539.21
8/21/20212726.255172.00-2445.75
8/22/20214849.254364.57484.68
8/23/20213778.505115.14-1336.64
8/24/20213225.503665.71-440.21
8/25/20214719.133601.571117.55
8/26/20213815.253517.00298.25
8/27/20214983.883913.861070.02
8/28/20214219.005315.14-1096.14
8/29/20213282.005555.86-2273.86
8/30/20213746.133921.57-175.45
8/31/20214939.504909.2930.21

Sample Chart #4 - Stacked Column/Bar

Use Hint

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

  • Q1 2020
  • Q2 2020
  • Q3 2020
  • Q4 2020
  • Q1 2021
  • Q2 2021
  • Q3 2021
  • Q4 2021

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.

Add-onQ1 2020Q2 2020Q3 2020Q4 2020Q1 2021Q2 2021Q3 2021Q4 2021
Table Filter139114145106106103148105
Smart Attachments5479696690965097
Awesome Graphs142128135195198179238192
Quizzes2048364233374629
Customer Case1510132518221719

Sample Chart #5 - Gantt

Use Hint

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

Task TypeTask DescriptionStart DateEnd DateCompletion
AnalysisOnsite Meetings8/1/20208/7/2020100%
AnalysisDiscussions with Stakeholders8/8/20208/20/2020100%
Analysis

Documenting Requirements

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

Integration of System Modules

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

1/25/2021

DevelopmentRC22/3/2021

Event

Date

Todaytoday
Meeting with Stakeholders10/5/2020
Payment3/15/2021
  • No labels