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”);