public static void ThreeDLine(Workbook workbook)
{
var worksheet = workbook.AddWorksheet("3-D Line");
var cellOffset = new PointDoubleUnit(19050, 19050, ScreenMeasurementUnit.Emu);
worksheet.GetRange("A1:A4").SetRowsHeight(66);
worksheet.GetRange("A8:A11").SetRowsHeight(66);
var chart1 = worksheet.Charts.AddLine3DChart(2, "Chart 1", "A1", cellOffset);
chart1.Size.HeightInches = 2.5;
chart1.Size.WidthInches = 3.5;
chart1.DataSource = "Data!$A$1:$D$5";
}
public static void TwoDArea(Workbook workbook)
{
var worksheet = workbook.AddWorksheet("2-D Area");
var cellOffset = new PointDoubleUnit(19050, 19050, ScreenMeasurementUnit.Emu);
worksheet.GetRange("A1:A4").SetRowsHeight(66);
worksheet.GetRange("A8:A11").SetRowsHeight(66);
var chart1 = worksheet.Charts.AddAreaChart(2, "Chart 1", "A1", cellOffset);
chart1.Size.HeightInches = 2.5;
chart1.Size.WidthInches = 3.5;
chart1.DataSource = "Data!$A$1:$D$5";
var chart2 = worksheet.Charts.AddAreaChart(3, "Chart 2", "A7", cellOffset);
chart2.Size.HeightInches = 2.5;
chart2.Size.WidthInches = 3.5;
chart2.Grouping = Grouping.Stacked;
chart2.DataSource = "Data!$A$1:$D$5";
}
