Add Secondary Chart Axis for Overlapped Column Chart Image
Hello,
How can I get these column bars to overlap?
Sample code snippet:
IPresentation pptxDoc = Presentation.Create(); // Create an instance of Presentation Renderer for converting chart to image pptxDoc.PresentationRenderer = new PresentationRenderer(); //Adds a blank slide to the Presentation ISlide slide = pptxDoc.Slides.Add(SlideLayoutType.Blank); //Adds chart to the slide with position and size IPresentationChart chart = slide.Charts.AddChart(100, 10, 700, 500); //Specifies the chart title chart.ChartTitle = "Sales Analysis"; //Specifies the chart type chart.ChartType = OfficeChartType.Column_Stacked; //Sets chart data - Row1 chart.ChartData.SetValue(1, 2, "Jan"); chart.ChartData.SetValue(1, 3, "Feb"); //Sets chart data - Row2 chart.ChartData.SetValue(2, 1, 2010); chart.ChartData.SetValue(2, 2, 900); chart.ChartData.SetValue(2, 3, 800); //Sets chart data - Row3 chart.ChartData.SetValue(3, 1, 2011); chart.ChartData.SetValue(3, 2, 800); chart.ChartData.SetValue(3, 3, 700); //Sets chart data - Row4 chart.ChartData.SetValue(4, 1, 2012); chart.ChartData.SetValue(4, 2, 700); chart.ChartData.SetValue(4, 3, 600); //Sets the data range of the category axis chart.PrimaryCategoryAxis.CategoryLabels = chart.ChartData[2, 1, 4, 1]; //Creates a new chart series with the name IOfficeChartSerie seriesJan = chart.Series.Add("Jan"); //Sets the data range of chart series – start row, start column, end row, end column seriesJan.Values = chart.ChartData[2, 2, 4, 2]; //Creates a new chart series with the name IOfficeChartSerie seriesFeb = chart.Series.Add("Feb"); //Sets the data range of chart series – start row, start column, end row, end column seriesFeb.Values = chart.ChartData[2, 3, 4, 3]; //Set the primary axis for the serie seriesFeb.UsePrimaryAxis = false; using (var stream = new MemoryStream()) { pptxDoc.PresentationRenderer.ConvertToImage(chart, stream); slide.Shapes.AddPicture(stream, 100, 10, 700, 500); } FileStream outputStream = new FileStream("Sample.pptx", FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite); pptxDoc.Save(outputStream); pptxDoc.Close(); outputStream.Flush(); outputStream.Dispose(); |
I'm using the latest Syncfusion.Presentation.Net.Core and Syncfusion.PresentationRenderer.Net.Core nuget package versions (v19.1.0.57)
Thanks in advance!
SIGN IN To post a reply.
6 Replies
Hi Lokesh,
Thanks for your reply, no I'd like an overlapped column chart rather than a stacked column chart.
I also tried using a Column_Clustered chart and setting the serie's Overlap format to 100% (using this documentation reference)
//Set the serie format of chart
serieFeb.SerieFormat.CommonSerieOptions.Overlap = 100;
serieFeb.SerieFormat.CommonSerieOptions.GapWidth= 50;But still the resulting chart image looks like this:
Hi Yasmin,
Thank you for you update.
Thank you for you update.
On further analysis on the given code snippet, we have found that when we create a chart using Essential Presentation and converting the chart to image and then save it as pptx. We have the same reported issue. Please refer to the screenshot given below.
 |
When we save as pptx document without converting chart to image, then we can achieve your requirement. We have prepared the sample to achieve your end requirement. Please refer to the sample link given below.
https://www.syncfusion.com/downloads/support/forum/165300/ze/PresentationSample160500476.zip
Please refer to the generated output from sample in the below screenshot.
 |
We have a different output between when export chart as image and not export chart as image. We suspect that this could be an issue. We will validate this issue and update you the further details on 13th May 2021.
If we misunderstood your requirement means, could you please share with us the expected output document. Thereby, we will check further on your requirement and will provide you the appropriate solution at the earliest.
Please let us know if you have any other questions.
Regards,
Lokesh B
SIGN IN To post a reply.
