

How to create Excel clustered column chart in C#, VB.NET?

This article explains how to create a clustered column chart in Excel using XlsIO.


What is a Clustered column chart?


Clustered column chart plots the data in the discrete vertical rectangles.


To create a Clustered column chart using XlsIO, you will need to do the following steps.


Clustered Column Chart Created using XlsIO

Steps to create the Clustered Column Chart


  1. Initialize chart


Create a chart object by calling the worksheet.Charts.Add method and specify the chart type to ExcelChartType.Column_Clustered enum value.



  1. Assign data





  1. Apply basic chart elements


Add the basic elements like chart title, data labels and legend with the below list of properties.


  • ChartTitle of chart object.
  • Set DataLabels via DefaultDataPoint.



Applicable Properties of Clustered Column Chart


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


1. GapWidth (value should be between 0 and 500)

2. Overlap (value should be between -100 and 100)

3. IsVarycolor


NOTE: Applying other properties apart from the above list might throw exception or the changes will not be reflected in the output document because those properties are not related to column/bar chart.


Download Complete Sample


Download input file with data




The following C#/ VB.NET complete code snippet shows the creation of clustered column chart using XlsIO.







8280 01/10/2018 03/09/2018 Windows Forms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment
