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);
}