/// <summary>
/// Adds a new pie chart to the worksheet.
/// </summary>
/// <param name="Name"></param>
/// <param name="ChartType">Type of chart</param>
/// <param name="PivotTableSource">The pivottable source for a pivotchart</param>
/// <returns>The chart</returns>
public ExcelPieChart AddPieChart(string Name, ePieChartType ChartType, ExcelPivotTable PivotTableSource)
{
return((ExcelPieChart)AddChart(Name, (eChartType)ChartType, PivotTableSource));
}
private static void PieStyles(ExcelWorksheet ws, ePieChartType chartType)
{
//Style 1
AddPie(ws, chartType, "PieChartStyle1", 0, 5, ePresetChartStyle.PieChartStyle1,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 2
var chart2 = AddPie(ws, chartType, "PieChartStyle2", 0, 18, ePresetChartStyle.PieChartStyle2,
c =>
{
c.Legend.Position = eLegendPosition.Top;
});
//Style 3
var chart3 = AddPie(ws, chartType, "PieChartStyle3", 0, 31, ePresetChartStyle.PieChartStyle3,
c =>
{
c.DataLabel.ShowPercent = true;
c.DataLabel.Position = eLabelPosition.Center;
});
//Style 4
AddPie(ws, chartType, "PieChartStyle4", 22, 5, ePresetChartStyle.PieChartStyle4,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 5
AddPie(ws, chartType, "PieChartStyle5", 22, 18, ePresetChartStyle.PieChartStyle5,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 6
AddPie(ws, chartType, "PieChartStyle6", 22, 31, ePresetChartStyle.PieChartStyle6,
c =>
{
});
//Style 7
AddPie(ws, chartType, "PieChartStyle7", 44, 5, ePresetChartStyle.PieChartStyle7,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 8
AddPie(ws, chartType, "PieChartStyle8", 44, 18, ePresetChartStyle.PieChartStyle8,
c =>
{
c.Legend.Position = eLegendPosition.Top;
c.DataLabel.ShowPercent = true;
c.DataLabel.Position = eLabelPosition.InEnd;
});
//Style 9
AddPie(ws, chartType, "PieChartStyle9", 44, 31, ePresetChartStyle.PieChartStyle9,
c =>
{
c.Legend.Remove();
c.DataLabel.ShowPercent = true;
c.DataLabel.ShowCategory = true;
c.DataLabel.ShowValue = true;
c.DataLabel.Position = eLabelPosition.OutEnd;
});
//Style 10
AddPie(ws, chartType, "PieChartStyle10", 66, 5, ePresetChartStyle.PieChartStyle10,
c =>
{
c.Legend.Remove();
c.DataLabel.ShowValue = true;
c.DataLabel.ShowPercent = true;
c.DataLabel.ShowCategory = true;
c.DataLabel.Position = eLabelPosition.InEnd;
});
//Style 11
AddPie(ws, chartType, "PieChartStyle11", 66, 18, ePresetChartStyle.PieChartStyle11,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
c.DataLabel.ShowPercent = true;
});
//Style 12
AddPie(ws, chartType, "PieChartStyle12", 66, 31, ePresetChartStyle.PieChartStyle12,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
c.DataLabel.Position = eLabelPosition.InEnd;
});
}
/// <summary>
/// Adds a new pie chart to the worksheet.
/// </summary>
/// <param name="Name"></param>
/// <param name="ChartType">Type of chart</param>
/// <returns>The chart</returns>
public ExcelPieChart AddPieChart(string Name, ePieChartType ChartType)
{
return((ExcelPieChart)AddChart(Name, (eChartType)ChartType, null));
}
private static void Pie3DStyles(ExcelWorksheet ws, ePieChartType ePieChartType)
{
//Style 1
AddPie(ws, ePieChartType, "PieChartStyle1", 0, 5, ePresetChartStyle.Pie3dChartStyle1,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 2
var chart2 = AddPie(ws, ePieChartType, "PieChartStyle2", 0, 18, ePresetChartStyle.Pie3dChartStyle2,
c =>
{
c.Legend.Remove();
c.DataLabel.ShowCategory = true;
c.DataLabel.ShowValue = true;
c.View3D.RotY = 50;
c.View3D.RotX = 50;
c.View3D.DepthPercent = 100;
c.View3D.RightAngleAxes = false;
});
//Style 3
AddPie(ws, ePieChartType, "PieChartStyle3", 0, 31, ePresetChartStyle.Pie3dChartStyle3,
c =>
{
c.DataLabel.ShowPercent = true;
c.DataLabel.Position = eLabelPosition.Center;
});
//Style 4
AddPie(ws, ePieChartType, "PieChartStyle4", 22, 5, ePresetChartStyle.Pie3dChartStyle4,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 5
AddPie(ws, ePieChartType, "PieChartStyle5", 22, 18, ePresetChartStyle.Pie3dChartStyle5,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 6
AddPie(ws, ePieChartType, "PieChartStyle6", 22, 31, ePresetChartStyle.Pie3dChartStyle6,
c =>
{
});
//Style 7
AddPie(ws, ePieChartType, "PieChartStyle7", 44, 5, ePresetChartStyle.Pie3dChartStyle7,
c =>
{
c.Legend.Position = eLegendPosition.Bottom;
});
//Style 8
AddPie(ws, ePieChartType, "PieChartStyle8", 44, 18, ePresetChartStyle.Pie3dChartStyle8,
c =>
{
c.Legend.Position = eLegendPosition.Top;
c.DataLabel.ShowPercent = true;
c.DataLabel.Position = eLabelPosition.InEnd;
});
//Style 9
AddPie(ws, ePieChartType, "PieChartStyle9", 44, 31, ePresetChartStyle.Pie3dChartStyle9,
c =>
{
c.Legend.Remove();
c.DataLabel.ShowPercent = true;
c.DataLabel.ShowCategory = true;
c.DataLabel.ShowValue = true;
c.DataLabel.Position = eLabelPosition.OutEnd;
});
//Style 10
AddPie(ws, ePieChartType, "PieChartStyle10", 66, 5, ePresetChartStyle.Pie3dChartStyle10,
c =>
{
c.Legend.Remove();
c.DataLabel.ShowValue = true;
c.DataLabel.ShowPercent = true;
c.DataLabel.ShowCategory = true;
c.DataLabel.Position = eLabelPosition.InEnd;
});
}