Create Graph and load data to graph using MSD axapta


 void createGraph1()  
 {  
 //SalesLine salesline;  
 LedgerBudget ledgerBudget;  
 int i,k;  
 str month;  
 // date createddate;  
 #macrolib.ChartFx  
 ;  
 graphics1 = Graphics::newGraphicsTitlesLayout(ChartX1, 100, 200,'Title', 'X', 'Y', 'z',1 ,1, 1, 1);  
 graphics1.create();  
 graphics1.parmTitle("MonthWise Comparison(G)");  
 graphics1.parmTitleXAxis('Month');  
 graphics1.parmTitleYAxis('Amount');  
 ChartX1.Chart3D(true);  
 ChartX1.toolBar(true);  
 //graphics.Gallery(9);  
 graphics1.parmHeight(350);  
 graphics1.parmWidth(450);  
 AllocApr=0;  
 AllocMay=0;  
 AllocJun=0;  
 AllocJul=0;  
 AllocAug=0;  
 AllocSept=0;  
 AllocOct=0;  
 AllocNov=0;  
 AllocDec=0;  
 AllocJan=0;  
 AllocFeb=0;  
 AllocMar=0;  
 while select * from LedgerBudget where LedgerBudget.Key!="" //ledgerBudget.AccountNum==ledgerTable.AccountNum  
 {  
 // DivisionName=divnm;  
 // if (salesline.createdDate >= fromDate &&  
 // salesline.createdDate <= toDate)  
 //  
  {  
 //switch(strFmt('%1',MthOfYr(LedgerJournalTable::findledgerJournalTrans.JournalNum).PostedDate)))  
  switch(strFmt('%1',MthOfYr( LedgerBudget.createdDate)))  
 {  
 case '4':  
 // info(strFmt('%1 %2', Year(_date), MthOfYr(_date) ));  
 AllocApr += LedgerBudget.Amount;  
 break;  
  case '5':  
 AllocMay += LedgerBudget.Amount; break;  
  case '6':  
 AllocJun += LedgerBudget.Amount;  
  break;  
 case '7':  
 AllocJul += LedgerBudget.Amount; break;  
  case '8':  
 AllocAug += LedgerBudget.Amount;  
 break;  
  case '9':  
  AllocSept += LedgerBudget.Amount;  
  break;  
 case '10':  
  AllocOct += LedgerBudget.Amount;  
 break;  
 case '11':  
 AllocNov += LedgerBudget.Amount;  
  break;  
 case '12':  
 AllocDec += LedgerBudget.Amount;  
 break;  
 case '1':  
 AllocJan += LedgerBudget.Amount;  
 break; case '2':  
 AllocFeb += LedgerBudget.Amount; break;  
 case '3':  
 AllocMar += LedgerBudget.Amount; break  
 ; }  
 }  
 for (k=0;k<12;k++)  
  {  
  if (k==0)  
 {  
 // if(AllocJan!=0)  
 {  
  graphics1.loadData("Jan","",AllocJan);  
  }  
 }  
  if (k==1)  
  {  
  // if(AllocFeb!=0)  
  {  
  graphics1.loadData("Feb","",AllocFeb);  
 }  
 }  
 if (k==2)  
 {  
  // if(AllocMar!=0)  
  {  
 graphics1.loadData("Mar","",AllocMar);  
 }  
 }  
 if (k==3)  
  {  
 // if(AllocApr!=0)  
 {  
  graphics1.loadData("Apr","",AllocApr);  
  }  
  }  
  if (k==4)  
 {  
 // if(AllocMay!=0)  
  {  
 graphics1.loadData("May","",AllocMay);  
 }  
 }  
 if (k==5)  
 {  
 // if(AllocJun!=0)  
 {  
  graphics1.loadData("Jun","",AllocJun);  
 }  
  }  
 if (k==6)  
  {  
 // if(AllocJul!=0)  
 {  
  graphics1.loadData("Jul","",AllocJul);  
 }  
 }  
  if (k==7)  
 {  
  // if(AllocAug!=0)  
 {  
 graphics1.loadData("Aug","",AllocAug); } }  
  if (k==8)  
 {  
 // if(AllocSept!=0)  
 {  
  graphics1.loadData("Sept","",AllocSept); } }  
  if (k==9)  
  {  
  // if(AllocOct!=0)  
  {  
 graphics1.loadData("Oct","",AllocOct);  
  }  
 }  
  if (k==10)  
 {  
 // if(AllocNov!=0)  
 {  
 graphics1.loadData("Nov","",AllocNov);  
  }  
  }  
  if (k==11)  
 {  
 // if(AllocDec!=0)  
 {  
 graphics1.loadData("Dec","",AllocDec);  
 }  
 }  
  }  
  graphics1.showGraph();  
 }