How to set column space for column charts in Word document?
Syncfusion Essential DocIO is a .NET Core Word library used to create, read, and edit Word documents programmatically without Microsoft Word or Interop dependencies. Using this library, you can set column space for column charts in the Word document in C#.
Steps to set column space for column charts in the Word document
- Create a new C# .NET Core console application project.
- Install the Syncfusion.DocIO.Net.Core NuGet package as a reference to your .NET Core applications from NuGet.org.
- Include the following namespace in the Program.cs file
C#
using Syncfusion.DocIO; using Syncfusion.DocIO.DLS; using Syncfusion.OfficeChart;
- For column charts, set the space between categories by using GapWidth property (value should be between 0 and 500) and set the space between series by using Overlap property (value should be between -100 and 100).
C#
//Set the gap between the category. serie1.SerieFormat.CommonSerieOptions.GapWidth = 200; //Set the gap between each series. serie1.SerieFormat.CommonSerieOptions.Overlap = -10;
- Use the following code example to set column space for column charts in the Word document.
C#
//Create a new Word document.
using (WordDocument document = new WordDocument())
{
//Add a section to the document.
IWSection section = document.AddSection();
//Add a paragraph to the section.
IWParagraph paragraph = section.AddParagraph();
//Create and append the chart to the paragraph.
WChart chart = paragraph.AppendChart(446, 270);
//Set chart type.
chart.ChartType = OfficeChartType.Column_Clustered;
//Set chart data.
chart.ChartData.SetValue(1, 1, "Fruits");
chart.ChartData.SetValue(2, 1, "Apples");
chart.ChartData.SetValue(3, 1, "Grapes");
chart.ChartData.SetValue(4, 1, "Bananas");
chart.ChartData.SetValue(5, 1, "Oranges");
chart.ChartData.SetValue(6, 1, "Melons");
chart.ChartData.SetValue(1, 2, "Joey");
chart.ChartData.SetValue(2, 2, 5);
chart.ChartData.SetValue(3, 2, 4);
chart.ChartData.SetValue(4, 2, 4);
chart.ChartData.SetValue(5, 2, 2);
chart.ChartData.SetValue(6, 2, 2);
chart.ChartData.SetValue(1, 3, "Matthew");
chart.ChartData.SetValue(2, 3, 3);
chart.ChartData.SetValue(3, 3, 5);
chart.ChartData.SetValue(4, 3, 4);
chart.ChartData.SetValue(5, 3, 1);
chart.ChartData.SetValue(6, 3, 7);
chart.ChartData.SetValue(1, 4, "Peter");
chart.ChartData.SetValue(2, 4, 2);
chart.ChartData.SetValue(3, 4, 2);
chart.ChartData.SetValue(4, 4, 3);
chart.ChartData.SetValue(5, 4, 5);
chart.ChartData.SetValue(6, 4, 6);
//Set region of Chart data.
chart.DataRange = chart.ChartData[1, 1, 6, 4];
//Set chart series in the column for assigned data region.
chart.IsSeriesInRows = false;
//Set Chart Title.
chart.ChartTitle = "Column Chart";
//Set Datalabels.
IOfficeChartSerie serie1 = chart.Series[0];
IOfficeChartSerie serie2 = chart.Series[1];
IOfficeChartSerie serie3 = chart.Series[2];
//Set the gap between the category.
serie1.SerieFormat.CommonSerieOptions.GapWidth = 200;
//Set the gap between each series.
serie1.SerieFormat.CommonSerieOptions.Overlap = -10;
//Set legend.
chart.HasLegend = true;
chart.Legend.Position = OfficeLegendPosition.Bottom;
//Create a file stream.
using (FileStream outputFileStream = new FileStream(Path.GetFullPath(@"../../../Sample.docx"), FileMode.Create, FileAccess.ReadWrite))
{
//Save the Word document to the file stream.
document.Save(outputFileStream, FormatType.Docx);
}
}
Similarly, set the column space for all types of column charts, line charts, clustered cone, cylinder and pyramid charts.
A complete working sample to set column space for column charts in the Word document in C# can be downloaded from GitHub.
By executing the program, you will get the output document as follows.
Take a moment to peruse the documentation, where you can find basic Word document processing options along with the features like mail merge, merge and split documents, find and replace text in the Word document, protect the Word documents, and most importantly, the PDF and Image conversions with code examples.
Explore more about the rich set of Syncfusion Word Framework features.
See Also:
How to set Date format in X axis of chart in Word document?
How to change scatter chart marker color for each data points in Word document?
Conclusion
Hope you enjoyed learning about how to set column space for column charts in Word document.
You can refer to our ASP.NET Core DocIO’s feature tour page to know about its other groundbreaking feature representations. You can explore our ASP.NET Core DocIO documentation to understand how to present and manipulate data.
For current customers, you can check out our ASP.NET Core components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our ASP.NET Core DocIO and other ASP.NET Core components.
If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
