How to create clustered bar chart in Word document using C#?

7 mins read

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 create clustered bar chart in Word document in C#.

What is a clustered bar chart?

A clustered bar chart plots the data in discrete horizontal rectangles.

Clustered Bar Chart in .NET Core Word library

Clustered Bar Chart in Word document

Steps to create clustered bar chart in Word document:

Initialize chart.

Create a chart object by calling the paragraph.AppendChart(446,270) method and specify the chart type to the OfficeChartType.Bar_Clustered enum value.

//Create and append the chart to the paragraph.
WChart chart = paragraph.AppendChart(446, 270);
//Set chart type.
chart.ChartType = OfficeChartType.Bar_Clustered;

Assign data and chart elements.

Add the basic elements like the chart title, data labels and legend.

ChartTitle of the chart object.
Set DataLabels using the DefaultDataPoint.
Set TRUE to the chart’s HasLegend property to show the legend, else False.

//Apply the chart elements.
//Set a chart title.
chart.ChartTitle = "Bar clustered chart";
 
//Set legend.
chart.HasLegend = true;
chart.Legend.Position = OfficeLegendPosition.Bottom;
 
//Set Datalabels.
IOfficeChartSerie series1 = chart.Series.Add("Series 1");
series1.Values = chart.ChartData[2, 2, 4, 2];
series1.DataPoints.DefaultDataPoint.DataLabels.IsValue = true;
series1.DataPoints.DefaultDataPoint.DataLabels.Position = OfficeDataLabelPosition.Center;

Applicable properties of clustered bar chart

Below is a list of other common properties applicable for a column/bar chart.

GapWidth (value should be between 0 and 500)
Overlap (value should be between -100 and 100)
IsVaryColor
Note:
Applying the properties apart from the mentioned list might throw an exception, or the changes will not be reflected in the output document because those properties are not related to the column/bar chart.

The following C# code sample shows the creation of a clustered bar chart using the Word library.

//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.Bar_Clustered;
    //Assign data.
    AddChartData(chart);
    //Set chart series in the column for assigned data region.
    chart.IsSeriesInRows = false;
    //Set a Chart Title.
    chart.ChartTitle = "Bar clustered chart";
    //Set Datalabels.
    IOfficeChartSerie series1 = chart.Series.Add("Series 1");
    //Set the data range of chart series – start row, start column, end row, and end column.
    series1.Values = chart.ChartData[2, 2, 4, 2];
    IOfficeChartSerie series2 = chart.Series.Add("Series 2");
    //Set the data range of chart series start row, start column, end row, and end column.
    series2.Values = chart.ChartData[2, 3, 4, 3];
    IOfficeChartSerie series3 = chart.Series.Add("Series 3");
    //Set the data range of chart series start row, start column, end row, and end column.
    series3.Values = chart.ChartData[2, 4, 4, 4];
    //Set the data range of the category axis.
    chart.PrimaryCategoryAxis.CategoryLabels = chart.ChartData[2, 1, 4, 1];
 
    //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);
    }
}

Helper method to set values of the chart in the Word document.

/// <summary>
/// Set the values for the chart.
/// </summary>
private static void AddChartData(WChart chart)
{
    //Set the value for chart data.
    chart.ChartData.SetValue(1, 2, "Series1");
    chart.ChartData.SetValue(1, 3, "Series2");
    chart.ChartData.SetValue(1, 4, "Series3");
 
    chart.ChartData.SetValue(2, 1, "Category1");
    chart.ChartData.SetValue(2, 2, 5);
    chart.ChartData.SetValue(2, 3, 4);
    chart.ChartData.SetValue(2, 4, 3);
 
    chart.ChartData.SetValue(3, 1, "Category2");
    chart.ChartData.SetValue(3, 2, 4);
    chart.ChartData.SetValue(3, 3, 5);
    chart.ChartData.SetValue(3, 4, 2);
 
    chart.ChartData.SetValue(4, 1, "Category3");
    chart.ChartData.SetValue(4, 2, 4);
    chart.ChartData.SetValue(4, 3, 4);
    chart.ChartData.SetValue(4, 4, 3);
}

A complete working sample of how to create clustered bar chart in Word document in C# can be downloaded from GitHub.

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 and an online example to create a chart in a Word document.

How to create clustered bar chart in Word document using C#?

What is a clustered bar chart?

Steps to create clustered bar chart in Word document:

Applicable properties of clustered bar chart

Access denied