private void AddPieChart() { var anchorRow = 5 + _budget.Categories.Count; var chartSpec = new ChartSpec() { Title = "Categories share", PieChart = new PieChartSpec() { LegendPosition = "LABELED_LEGEND", PieHole = 0.65, Series = new ChartData() { SourceRange = new ChartSourceRange() { Sources = new List <GridRange>() { new GridRange() { StartColumnIndex = 1, EndColumnIndex = 2, StartRowIndex = 1, EndRowIndex = 2 + _budget.Categories.Count, SheetId = 2, } } } }, Domain = new ChartData() { SourceRange = new ChartSourceRange() { Sources = new List <GridRange>() { new GridRange() { StartColumnIndex = 0, EndColumnIndex = 1, StartRowIndex = 1, EndRowIndex = 2 + _budget.Categories.Count, SheetId = 2, } } } } } }; _googleSheetService.AddChart(0, anchorRow, chartSpec); }