Free Support Forum - aspose.com

3d histogram Excel

Hello,
is it possible to generate excel files with 3d histograms inside? can someone give me the documentation?
Thank you in advance.

@ExtraDev,
Thank you for your query.

Aspose.Cells currently does not support Histogram charts. A request to implement this feature is already logged and same is being linked with this thread. You will be automatically notified once this feature will be implemented and updated DLL will be available online for download. Please note that no ETA is available yet for it due to its complexity. We will write back here once any update is ready to share.

1 Like

@ExtraDev,
We have investigated it more, ChartType.Histogram is supported. See the document with examples about creating charts.
https://docs.aspose.com/display/cellsnet/Creating+and+Customizing+Charts

If you still need help then share expected output worksheet created by MS Excel.

1 Like

thank you for your answer, i want to create like this 3d histogram.
3dhistogram.png (15.9 KB)

@ExtraDev,
We are working on this issue and request you to send us the source template Excel file whose image you have sent. We need the Excel file for our reference.

Hello, thank you for your answers.
here is the excel file.
KPI.zip (11.4 KB)
is it possible to do the same with Aspose?

@ExtraDev,
We have checked the sample Excel file and observed that it is Column3D type chart. You may verify this by running the following sample code to create a similar chart and share the feedback.

    Workbook workbook = new Workbook("KPI 2.xlsx");
    Worksheet worksheet = workbook.Worksheets[0];
    int chartIndex = worksheet.Charts.Add(ChartType.Column3D, 0, 3, 28, 11);
    Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex];

    chart.NSeries.Add("=Feuil1!$B$2:$B$8", true);
    chart.NSeries[0].Name = "=Feuil1!$B$1";

    chart.NSeries.Add("=Feuil1!$C$2:$C$8", true);
    chart.NSeries[1].Name = "=Feuil1!$C$1";

    chart.NSeries.CategoryData = "=Feuil1!$A$2:$A$8";

    chart.Title.Text = "Chart title";
    chart.Legend.Position = LegendPositionType.Bottom;

    chart.PlotArea.Area.ForegroundColor = Color.White;

    chart.PlotArea.Border.IsVisible = false;
    // Saving the Excel file
    workbook.Save("KPI 2_Output.xlsx");

KPI 2_Output.xlsx.zip (9.2 KB)
KPI 2.xlsx.zip (7.0 KB)
Comparison.jpg (643.2 KB)

1 Like

thank you very much for your help, I will make a feedback after the realization of the graph.

@ExtraDev,
You are welcome.