Versions Compared

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. It allows you to generate dynamically updated charts with a capability to instantly switch between columns with different data values.

Parameters

...

Chart

...

titleClick here to expand the list of parameters...

...

The column containing labels for data values.

...

The column containing numerical values for chart generation.

...

None

(dependable on screen area)

...

None

(dependable on screen area)

...

Minimal X Value

...

You can specify the required scale step of X axis for showing the chart.

...

Chart Examples

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

...

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 2014Q2 2014Q3 2014Q4 2014Q1 2015Q2 2015Q3 2015Q4 2015
Table Filter139114145106106103148105
Smart Attachments5479696690965097
Awesome Graphs142128135195198179238192
Quizzes2048364233374629
Customer Case1510132518221719

 

...

Sample Chart #5

Info
titleUse Hint

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

Chart from Table
dataorientationVertical
legendright
columnTask Type‚Task Description‚Milestone‚Event
aggregationStart Date‚End Date‚Completion‚Date
is3dfalse
alignCenter
typeGantt
separatorPoint (.)
version2
colors#8eb021,#d8d23a,#69a6f9,#d04437,#0c6197,#a3acb2,#3572b0,#cc1010,#31383b,#f6c342,#e98125,#6ada6a,#654982,#e4a14b,#8cc3e9,#d8d23a,#f691b2,#2484c1
hidefalse
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 with Stakeholders‚Payment
id1513330486549_-1286331324
worklog7|10|h
Task TypeTask DescriptionStart DateEnd DateCompletion
AnalysisOnsite Meetings8/1/20178/7/2017100%
AnalysisDiscussions with Stakeholders8/8/20178/20/2017100%
Analysis

Documenting Requirements

8/15/20178/25/201795%
AnalysisCreation of Mockups8/20/20179/7/201795%
AnalysisVerification of Requirements9/5/20179/15/201750%
DesignDesign Database9/15/20179/25/20170%
DesignSoftware Design9/25/201710/1/20170%
DesignInterface Design10/5/201710/15/20170%
DesignCreate Design Specifications10/17/201710/25/20170%
DesignVerification of Design Specifications10/28/201711/7/20170%
DevelopmentDevelopment of System Modules10/15/201712/31/20170%
Development

Integration of System Modules

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

1/25/2018

DevelopmentRC22/3/2018

Event

Date

Todaytoday
Meeting with Stakeholders12/5/2017
Payment3/15/2018