Articles in this section
Category / Section

How to create bubble chart in Word document using C# and VB.NET

4 mins read

What is a bubble chart?

A bubble chart represents data points with bubbles along with an additional dimension of the data, size of the bubbles. Like a scatter chart, a bubble chart does not use a category axis. Both x (horizontal) and y(vertical) axes are value axes in addition with z (size) values.

Bubble chart

Bubble chart created using Word library (Essential DocIO)

Steps to create bubble chart in Word document using DocIO library

  1. Initialize chart

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

//Creates and Appends chart to the paragraph.
WChart chart = paragraph.AppendChart(446, 270);
//Sets chart type.
chart.ChartType = OfficeChartType.Bubble;
  1. Assign data and chart elements

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

  • ChartTitle of chart object.
  • Set DataLabels via DefaultDataPoint.
  • Add CategoryLabels and Values.
  • Set TRUE to chart’s HasLegend property to show the legend, else False.
    //Apply chart elements.
    //Set chart title.
    chart.ChartTitle = "Bubble Chart";
     
    //Set legend.
    chart.HasLegend = false;
     
    //Set Datalabels, CategoryLabels, and Values.
    IOfficeChartSerie serie = chart.Series.Add();
    serie.CategoryLabels = chart.ChartData[2, 1, 11, 1];
    serie.Values = chart.ChartData[2, 2, 11, 2];
    serie.Bubbles = chart.ChartData[2, 3, 11, 3];
    serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = true;
    serie.DataPoints.DefaultDataPoint.DataLabels.Position = OfficeDataLabelPosition.Center;
    

 

Applicable properties of bubble chart

  • SizeRepresents
  • BubbleScale
  • ShowNegativeBubbles

 

Note:
  • Applying properties apart from the mentioned list might throw exception or the changes will not be reflected in the output document because those properties are not related to bubble chart.
  • Bubbles with negative size are said to be the negative bubbles.

 

 

The following C# and VB.NET complete code snippet shows the creation of bubble chart using Word library.

C#

using Syncfusion.DocIO;
using Syncfusion.DocIO.DLS;
using Syncfusion.OfficeChart;
using System.IO;
 
namespace ChartSample
{
    class Program
    {
        static void Main(string[] args)
        {
            //Loads the template document.
            WordDocument document = new WordDocument();
            // Adds section to the document.
            IWSection sec = document.AddSection();
            //Adds paragraph to the section.
            IWParagraph paragraph = sec.AddParagraph();
            //Creates and Appends chart to the paragraph.
            WChart chart = paragraph.AppendChart(446, 270);
            //Sets chart type.
            chart.ChartType = OfficeChartType.Bubble;
 
            //Apply chart elements.
            //Set chart title.
            chart.ChartTitle = "Bubble Chart";
            //Set data to the chart
            SetChartData(chart);
 
            //Set Datalabels, CategoryLabels, and Values.
            IOfficeChartSerie serie = chart.Series.Add();
            serie.CategoryLabels = chart.ChartData[2, 1, 11, 1];
            serie.Values = chart.ChartData[2, 2, 11, 2];
            serie.Bubbles = chart.ChartData[2, 3, 11, 3];
            serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = true;
            serie.DataPoints.DefaultDataPoint.DataLabels.Position = OfficeDataLabelPosition.Center;
 
            //Saves and closes the document.
            document.Save("sample.docx", FormatType.Docx);
            document.Close();
        }
 
        /// <summary>
        /// Set the values for the chart.
        /// </summary>
        /// <param name="chart">Represent the instance of the WordDocument chart</param>
        private static void SetChartData(WChart chart)
        {
            chart.ChartData.SetValue(1, 1, "X");
            chart.ChartData.SetValue(2, 1, -10);
            chart.ChartData.SetValue(3, 1, -20);
            chart.ChartData.SetValue(4, 1, -30);
            chart.ChartData.SetValue(5, 1, -40);
            chart.ChartData.SetValue(6, 1, -50);
            chart.ChartData.SetValue(7, 1, 10);
            chart.ChartData.SetValue(8, 1, 20);
            chart.ChartData.SetValue(9, 1, 30);
            chart.ChartData.SetValue(10, 1, 40);
            chart.ChartData.SetValue(11, 1, 50);
            chart.ChartData.SetValue(1, 2, "Y");
            chart.ChartData.SetValue(2, 2, -100);
            chart.ChartData.SetValue(3, 2, -200);
            chart.ChartData.SetValue(4, 2, -300);
            chart.ChartData.SetValue(5, 2, -400);
            chart.ChartData.SetValue(6, 2, -500);
            chart.ChartData.SetValue(7, 2, 100);
            chart.ChartData.SetValue(8, 2, 200);
            chart.ChartData.SetValue(9, 2, 300);
            chart.ChartData.SetValue(10, 2, 400);
            chart.ChartData.SetValue(11, 2, 500);
            chart.ChartData.SetValue(1, 3, "Size");
            chart.ChartData.SetValue(2, 3, 1);
            chart.ChartData.SetValue(3, 3, -1);
            chart.ChartData.SetValue(4, 3, 1);
            chart.ChartData.SetValue(5, 3, -1);
            chart.ChartData.SetValue(6, 3, 1);
            chart.ChartData.SetValue(7, 3, -1);
            chart.ChartData.SetValue(8, 3, 1);
            chart.ChartData.SetValue(9, 3, -1);
            chart.ChartData.SetValue(10, 3, 1);
            chart.ChartData.SetValue(11, 3, -1);
        }

 

VB

Imports Syncfusion.DocIO
Imports Syncfusion.DocIO.DLS
Imports Syncfusion.OfficeChart
 
Namespace ChartSample
    Class Program
        Private Shared Sub Main(ByVal args As String())
            'Loads the template document.
            Dim document As WordDocument = New WordDocument()
            ' Adds section to the document.
            Dim sec As IWSection = document.AddSection()
            'Adds paragraph to the section.
            Dim paragraph As IWParagraph = sec.AddParagraph()
            'Creates and Appends chart to the paragraph.
            Dim chart As WChart = paragraph.AppendChart(446, 270)
            'Sets chart type
            chart.ChartType = OfficeChartType.Bubble
 
            'Apply chart elements.
            'Set chart title.
            chart.ChartTitle = "Bubble Chart"
            'Set data to the chart.
            Program.SetChartData(chart)
 
            'Set Datalabels, CategoryLabels, and Values.
            Dim serie As IOfficeChartSerie = chart.Series.Add()
            serie.CategoryLabels = chart.ChartData(2, 1, 11, 1)
            serie.Values = chart.ChartData(2, 2, 11, 2)
            serie.Bubbles = chart.ChartData(2, 3, 11, 3)
            serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = True
            serie.DataPoints.DefaultDataPoint.DataLabels.Position = OfficeDataLabelPosition.Center
 
            'Saves and closes the document.
            document.Save("sample.docx", FormatType.Docx)
            document.Close()
        End Sub
 
 
        ''' <summary>
        ''' Set the values for the chart
        ''' </summary>
        ''' <paramname="chart">Represent the instance of the WordDocument chart</param>
        Private Shared Sub SetChartData(ByVal chart As WChart)
            chart.ChartData.SetValue(1, 1, "X")
            chart.ChartData.SetValue(2, 1, -10)
            chart.ChartData.SetValue(3, 1, -20)
            chart.ChartData.SetValue(4, 1, -30)
            chart.ChartData.SetValue(5, 1, -40)
            chart.ChartData.SetValue(6, 1, -50)
            chart.ChartData.SetValue(7, 1, 10)
            chart.ChartData.SetValue(8, 1, 20)
            chart.ChartData.SetValue(9, 1, 30)
            chart.ChartData.SetValue(10, 1, 40)
            chart.ChartData.SetValue(11, 1, 50)
            chart.ChartData.SetValue(1, 2, "Y")
            chart.ChartData.SetValue(2, 2, -100)
            chart.ChartData.SetValue(3, 2, -200)
            chart.ChartData.SetValue(4, 2, -300)
            chart.ChartData.SetValue(5, 2, -400)
            chart.ChartData.SetValue(6, 2, -500)
            chart.ChartData.SetValue(7, 2, 100)
            chart.ChartData.SetValue(8, 2, 200)
            chart.ChartData.SetValue(9, 2, 300)
            chart.ChartData.SetValue(10, 2, 400)
            chart.ChartData.SetValue(11, 2, 500)
            chart.ChartData.SetValue(1, 3, "Size")
            chart.ChartData.SetValue(2, 3, 1)
            chart.ChartData.SetValue(3, 3, -1)
            chart.ChartData.SetValue(4, 3, 1)
            chart.ChartData.SetValue(5, 3, -1)
            chart.ChartData.SetValue(6, 3, 1)
            chart.ChartData.SetValue(7, 3, -1)
            chart.ChartData.SetValue(8, 3, 1)
            chart.ChartData.SetValue(9, 3, -1)
            chart.ChartData.SetValue(10, 3, 1)
            chart.ChartData.SetValue(11, 3, -1)
        End Sub
    End Class
End Namespace

 

A complete working example of how to create bubble chart in Word document in C# can be downloaded from Create-bubble-chart-in-Word.zip.

To learn more about creating charts with various settings using Syncfusion Word library (Essential DocIO), please refer the documentation.

An online example to create chart in Word document.

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied