Can anybody please let me know if ASPOSE supports creation of Downtime Pareto and Waterfall chart using ASPOSE.EXCEL. If so how to do that.
Also, if any other means of getting this done using ASPOSE.
Thanks,
-Santhosh
@santhosh,
Aspose.Excel is discarded and no more continued now. It is replaced with Aspose.Cells which has support for all the latest features and chart types in different versions of MS Excel. You can create Pareto and waterfall graphs as shown in the following sample code:
Pareto Graph
Workbook workbook = new Workbook();
int index = workbook.Worksheets.Add();
Worksheet worksheet = workbook.Worksheets[index];
worksheet.Cells[0, 0].PutValue("Defect Case");
worksheet.Cells[0, 1].PutValue("Qty");
worksheet.Cells[1, 0].PutValue("Cut not straight");
worksheet.Cells[1, 1].PutValue(9);
worksheet.Cells[2, 0].PutValue("No defect found");
worksheet.Cells[2, 1].PutValue(7);
worksheet.Cells[3, 0].PutValue("Product not made by FLC");
worksheet.Cells[3, 1].PutValue(3);
worksheet.Cells[4, 0].PutValue("Sample lost");
worksheet.Cells[4, 1].PutValue(3);
worksheet.Cells[5, 0].PutValue("Incorrect hose cut length");
worksheet.Cells[5, 1].PutValue(3);
worksheet.Cells[6, 0].PutValue("Mechanical failure");
worksheet.Cells[6, 1].PutValue(2);
worksheet.Cells[7, 0].PutValue("Missing quantity");
worksheet.Cells[7, 1].PutValue(1);
worksheet.Cells[8, 0].PutValue("Accessories");
worksheet.Cells[8, 1].PutValue(1);
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.ParetoLine, 5, 0, 40, 19);
string dataArea = "B2: B9";
string categoryArea = "A2: A9";
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex];
chart.NSeries.Add(dataArea, true);
chart.PlotArea.BackgroundMode = Aspose.Cells.Charts.BackgroundMode.Transparent;
chart.PlotArea.Area.ForegroundColor = Color.Transparent;
chart.ChartArea.Area.ForegroundColor = Color.FromArgb(242, 242, 242);
chart.ChartArea.BackgroundMode = Aspose.Cells.Charts.BackgroundMode.Automatic;
chart.ChartArea.Font.Color = Color.DarkBlue;
chart.CategoryAxis.CategoryType = Aspose.Cells.Charts.CategoryType.AutomaticScale;
chart.CategoryAxis.TickLabelSpacing = 60;
chart.NSeries.CategoryData = categoryArea;
chart.NSeries[0].Name = "= B1";
chart.ShowLegend = false;
workbook.Save("prova.xlsx", SaveFormat.Xlsx);
Aspose.Cells.Rendering.ImageOrPrintOptions imgOptions = new Aspose.Cells.Rendering.ImageOrPrintOptions();
imgOptions.ImageType = Aspose.Cells.Drawing.ImageType.Png;
imgOptions.HorizontalResolution = 300;
imgOptions.VerticalResolution = 300;
chart.ToImage(@"prova.png", imgOptions);
Waterfall Graph
// Create an instance of Workbook
Workbook workbook = new Workbook();
// Retrieve the first Worksheet in Workbook
Worksheet worksheet = workbook.Worksheets[0];
// Retrieve the Cells of the first Worksheet
var cells = worksheet.Cells;
// Input some data which chart will use as source
cells["A1"].PutValue("Previous Year");
cells["A2"].PutValue("January");
cells["A3"].PutValue("March");
cells["A4"].PutValue("August");
cells["A5"].PutValue("October");
cells["A6"].PutValue("Current Year");
cells["B1"].PutValue(8.5);
cells["B2"].PutValue(1.5);
cells["B3"].PutValue(7.5);
cells["B4"].PutValue(7.5);
cells["B5"].PutValue(8.5);
cells["B6"].PutValue(3.5);
cells["C1"].PutValue(1.5);
cells["C2"].PutValue(4.5);
cells["C3"].PutValue(3.5);
cells["C4"].PutValue(9.5);
cells["C5"].PutValue(7.5);
cells["C6"].PutValue(9.5);
// Add a Chart of type Line in same worksheet as of data
int idx = worksheet.Charts.Add(ChartType.Line, 4, 4, 25, 13);
// Retrieve the Chart object
Chart chart = worksheet.Charts[idx];
// Add Series
chart.NSeries.Add("$B$1:$C$6", true);
// Add Category Data
chart.NSeries.CategoryData = "$A$1:$A$6";
// Series has Up Down Bars
chart.NSeries[0].HasUpDownBars = true;
// Set the colors of Up and Down Bars
chart.NSeries[0].UpBars.Area.ForegroundColor = Color.Green;
chart.NSeries[0].DownBars.Area.ForegroundColor = Color.Red;
// Make both Series Lines invisible
chart.NSeries[0].Border.IsVisible = false;
chart.NSeries[1].Border.IsVisible = false;
// Set the Plot Area Formatting Automatic
chart.PlotArea.Area.Formatting = FormattingType.Automatic;
// Delete the Legend
chart.Legend.LegendEntries[0].IsDeleted = true;
chart.Legend.LegendEntries[1].IsDeleted = true;
// Save the workbook
workbook.Save(dataDir + "output_out.xlsx");
A detailed document section with description and sample code to create variety of charts is available here:
Charts
Following link directs to the free trial version of this product:
Aspose.Cells for .NET(Latest version)
A detailed runnable solution containing lot of ready to run examples is available here.