Hi All,
I generated Area chart and got generated successfully only when I hard code values in C#.
But when I generate data table and bind to excel using (WorkSheet.Cells.ImportDataTable(dt,true,"A1")) and try to generate Area chart, it is blank.
My code is given below.
Worksheet sheet = workbook.Worksheets[0];
sheet.Cells.ImportDataTable(dtBaseLoad, true, "A1");
int chartIndex = 0;
chartIndex = sheet.Charts.Add(Aspose.Cells.ChartType.Area, 9, 1, 33, 10);
Aspose.Cells.Chart chart = sheet.Charts[chartIndex];
chart.Legend.Position = Aspose.Cells.LegendPositionType.Top;
chart.CategoryAxis.MajorGridLines.IsVisible = false;
chart.Title.Text = "Sales By Region";
chart.Title.TextFont.Color = System.Drawing.Color.Black;
chart.Title.TextFont.IsBold = true;
chart.Title.TextFont.Size = 12;
chart.NSeries.Add("B2:M6", false);
chart.NSeries.CategoryData = "B1:M1";
chart.NSeries.IsColorVaried = true;
chart.CategoryAxis.Title.Text = "Year(2002-2006)";
chart.CategoryAxis.Title.TextFont.Color = System.Drawing.Color.Black;
chart.CategoryAxis.Title.TextFont.IsBold = true;
chart.CategoryAxis.Title.TextFont.Size = 10;
chart.CategoryAxis.AxisBetweenCategories = false;
When I double click on data in excel, then the graph is getting displayed.
What could be the problem and how to resolve it.
Please advise.
Sweatha