Sunday, July 12, 2015

Gantt Chart in Spotfire

About Gantt Chart:
It illustrate the start and finish dates of the terminal elements and summary elements of a project/project tasks. 

Their is no Gantt Chart in Spotfire but we have a work around to get the same using Scatter Visualization. 

Raw Data:-







Steps:-
Unpivot the data while importing from source as below

  


Now create a scatter Visualization with Y Axis as Project and X Axis as Time Period (i.e., Value in our data table) and visualization properties as below:






 You will get the o/p result as Gannt Chart.







4 comments:

  1. Does just what I need. Thanks. And by linking the unpivoted table to the original table I don't lose any of the other data I needed.

    ReplyDelete