We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Simple Example of Bubble chart

Hi ,

i’m very happy with the product aspose and i’m working with it.
if possible i need a simple example that show how to create a bubble chart in aspose.
i tried to find one in the forum and also in the docs but no luck in that.
thanks

Hi,


Please see the sample example code for Bubble chart below for your reference:

Sample code:
Workbook AsposeBook = new Workbook();
int SheetIndex = AsposeBook.Worksheets.Add();
Worksheet ActualChartSheet = AsposeBook.Worksheets[SheetIndex];
SheetIndex = AsposeBook.Worksheets.Add();
Worksheet DataSheet = AsposeBook.Worksheets[SheetIndex];
DataSheet.IsVisible = false;
DataSheet.Name = “DataSheet”;


int ChartIndex = ActualChartSheet.Charts.Add(ChartType.Line, 0, 0, 30, 10);
Chart ActualChart = ActualChartSheet.Charts[ChartIndex];


double[] XValues = { 2.4, 0.3, 0.2, 1.1, 2.3, 2.1, 0.3, 0.2, 0.128, 0.4, 0.2, 1.2, 0.7, 0.13, 0.13 };
double[] Yvalues = { 0.867, -0.00141, 0.113, 0.028, 0.399, -0.18, 0.072, -0.237, 0.420, -0.132, -0.0125, 0.0405, -0.0479, -0.112, -0.1441 };
double[] ZValues = { 1991446, 1416791, 1266904, 942250, 803036, 731421, 344330, 333208, 261988, 260854, 252742, 193094, 180512, 158543, 145193 };


ActualChart.Title.Text = “Example Bubble Chart”;
SeriesCollection AspSeries = ActualChart.NSeries;
int SerieCount = AspSeries.Add(“DataSheet!A1:A15”, true);
Series MySerie = AspSeries[SerieCount];
MySerie.Type = ChartType.Bubble3D;
MySerie.PlotOnSecondAxis = false;
MySerie.Name = “Example Bubble Chart”;


DataSheet.Cells.ImportArray(XValues, 0, 0, true);
MySerie.XValues = “DataSheet!$A$1:$A$15”;
DataSheet.Cells.ImportArray(Yvalues, 0, 1, true);
MySerie.Values = “DataSheet!$B$1:$B$15”;
DataSheet.Cells.ImportArray(ZValues, 0, 2, true);
MySerie.BubbleSizes = “DataSheet!$C$1:$C$15”;


for (int I = 0; I < MySerie.Points.Count; I++)
{
MySerie.Points[I].DataLabels.Text = (I + 1).ToString();
}

ActualChart.ValueAxis.MinorGridLines.IsVisible = false;
ActualChart.ValueAxis.MajorGridLines.IsVisible = false;
ActualChart.ValueAxis.MaxValue = 1.2;
ActualChart.ValueAxis.MinValue = -0.6;
ActualChart.ValueAxis.CrossAt = 0.31;
ActualChart.ValueAxis.TickLabelPosition = TickLabelPositionType.High;


ActualChart.CategoryAxis.MajorGridLines.IsVisible = false;
ActualChart.CategoryAxis.MajorGridLines.IsVisible = false;
ActualChart.CategoryAxis.IsLogarithmic = true;
ActualChart.CategoryAxis.IsPlotOrderReversed = true;
ActualChart.CategoryAxis.LogBase = 2;
ActualChart.CategoryAxis.MaxValue = 8;
ActualChart.CategoryAxis.MinValue = 0.125;
ActualChart.CategoryAxis.CrossAt = 1.5;
ActualChart.CategoryAxis.TickLabelPosition = TickLabelPositionType.Low;


ActualChart.ShowLegend = false;
AsposeBook.Save(“e:\test2\Sample_bubble_chart.xlsx”);