Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
145
Column Chart not displaying data
posted

I am trying to create a column chart from JSON data in Asp.Net MVC, I have a an ajax call getting JSON object returned from a controller that looks like this

 

[{"FiscalPeriod":"01","FullTimeEmployeeNeeded":0,"Employees":6320,"Contractors":2685},{"FiscalPeriod":"02","FullTimeEmployeeNeeded":0,"Employees":12504,"Contractors":0},{"FiscalPeriod":"03","FullTimeEmployeeNeeded":415,"Employees":19894,"Contractors":7035},{"FiscalPeriod":"04","FullTimeEmployeeNeeded":1639,"Employees":25942,"Contractors":9864},{"FiscalPeriod":"05","FullTimeEmployeeNeeded":2689,"Employees":30542,"Contractors":10697},{"FiscalPeriod":"06","FullTimeEmployeeNeeded":3897,"Employees":36102,"Contractors":11697},{"FiscalPeriod":"07","FullTimeEmployeeNeeded":4857,"Employees":39150,"Contractors":12377},{"FiscalPeriod":"08","FullTimeEmployeeNeeded":5817,"Employees":42110,"Contractors":13017},{"FiscalPeriod":"09","FullTimeEmployeeNeeded":7017,"Employees":49690,"Contractors":13639},{"FiscalPeriod":"10","FullTimeEmployeeNeeded":7977,"Employees":55754,"Contractors":13943},{"FiscalPeriod":"11","FullTimeEmployeeNeeded":8937,"Employees":58410,"Contractors":14063},{"FiscalPeriod":"12","FullTimeEmployeeNeeded":9186,"Employees":65990,"Contractors":14063}]

My code that creates the graph is

function createGraph(object) {
 
 
       $("#chart").igDataChart({
           dataSouce: object,
           title: "Cumulative Data",
           height: "550px",
           width: "98%",
           legend: { element: "legend" },
           axes: [{
               name: "xAxis",
               type: "categoryX",
                   label: "FiscalPeriod",
                   title: "FiscalPeriod"
               },
               {
                   name: "yAxis",
                   type: "numericY",
                   title: "Hours",  
                   minimumValue: 0 
               }
           ],
           series:   [ 
               {
                   name: "series1",
                   title: "Employees",
                   xAxis:  "xAxis",
                   yAxis: "yAxis",
                   valueMemberPath: "Employees",
                   type: "column"
               }
               
               ,{
                   name: "series2",
                   title: "Contractors",
                   valueMemberPath: "Contractors",
                   xAxis:  "xAxis",
                   yAxis: "yAxis",
                   type: "column"
               },
               
               {
                   name: "series3",
                   title: "Full Time Employee Needed",
                   valueMemberPath: "FullTimeEmployeeNeeded",
                   xAxis:  "xAxis",
                   yAxis: "yAxis",
                   type: "column"
               }] ,
           horizontalZoomable: true,
           verticalZoomable: true,
           windowResponse: "immediate"
       });
   }

The issue is that it does not display any of the columns, x and y axis labels. It does display the proper names in the legend, but that is the only thing it displays correctly