public void GetAnalyticsByMonth(DataGridView dataGridView, Chart chartColumn) { var transaction = _analyticsService.GetAnalyticsByMonth(); var credit = transaction.Select(x => x.Credit).ToList(); var debit = transaction.Select(x => - x.Debit).ToList(); var balance = transaction.Select(x => x.Balance).ToList(); var month = transaction.Select(x => x.Date.ToString("MMM")).ToList(); chartColumn.Series[0].Points.DataBindXY(month, credit); chartColumn.Series[1].Points.DataBindXY(month, debit); chartColumn.Series[2].Points.DataBindXY(month, balance); dataGridView.DataSource = transaction; }