7 Replies Latest reply: Nov 26, 2013 12:29 PM by Alberto Varela RSS

    want to build graph using dashboard from excel

      I have a data in an excel which has 1st three columns as project1, sub project and sub-sub project, and the fourth column is KPI metrics and the 5th column is target and the 6th column onwards are months and the data in each of the columns below.

       

      Header 1Header 2Header 3Header 4Header 5Header 6
      ProjectSub-ProjectSub-Sub-projectKPITargetAug
      A&AA&A (Adam)A&A (Adam - Aple)Answerd90%93%
      Abnd<5%4.1%
      FCR90%92%

      Want to show a graphical presentation of the above data with the multibox showing 'Project', 'Sub-Project'and 'Sub-Sub-project' and the values of all the KPI's show for Aug shown in the Bar graph.

      Added a dummy data for reference herewith.