static void CreateChart(IDrawing drawing, ISheet sheet, IClientAnchor anchor, string serie1, string serie2, bool enableMajorGridline = false)
{
XSSFChart chart = (XSSFChart)drawing.CreateChart(anchor);
chart.SetTitle("Test 1");
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.TopRight;
ILineChartData <double, double> data = chart.ChartDataFactory.CreateLineChartData <double, double>();
// Use a category axis for the bottom axis.
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
IChartDataSource <double> xs = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
var s1 = data.AddSeries(xs, ys1);
s1.SetTitle(serie1);
var s2 = data.AddSeries(xs, ys2);
s2.SetTitle(serie2);
chart.Plot(data, bottomAxis, leftAxis);
//add major gridline, available since NPOI 2.5.5
var plotArea = chart.GetCTChart().plotArea;
plotArea.catAx[0].AddNewMajorGridlines();
plotArea.valAx[0].AddNewMajorGridlines();
}
public void TestExistingChartNoTitle()
{
IWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("chartTitle_noTitle.xlsx");
XSSFChart chart = GetChartFromWorkbook(wb, "Sheet1");
Assert.IsNotNull(chart);
Assert.IsNull(chart.Title);
String myTitle = "My chart title";
chart.SetTitle(myTitle);
XSSFRichTextString queryTitle = chart.Title;
Assert.IsNotNull(queryTitle);
Assert.AreEqual(myTitle, queryTitle.ToString());
}
public void TestNewChart()
{
IWorkbook wb = CreateWorkbookWithChart();
XSSFChart chart = GetChartFromWorkbook(wb, "linechart");
Assert.IsNotNull(chart);
Assert.IsNull(chart.Title);
String myTitle = "My chart title";
chart.SetTitle(myTitle);
XSSFRichTextString queryTitle = chart.Title;
Assert.IsNotNull(queryTitle);
Assert.AreEqual(myTitle, queryTitle.ToString());
}
