Hi:
I'm using version 4.8.2 to build a bubble chart with there axis on different positions, but the result is not what I'm expecting. Both axis are not crossing where I'm indicating.
I hope you can help me.
Sincerely
Alejandro
var AsposeBook = new Workbook();
int SheetIndex = AsposeBook.Worksheets.Add();
var ActualChartSheet = AsposeBook.Worksheets[SheetIndex];
SheetIndex = AsposeBook.Worksheets.Add();
var DataSheet = AsposeBook.Worksheets[SheetIndex];
DataSheet.IsVisible = false;
DataSheet.Name = "DataSheet";
int ChartIndex = ActualChartSheet.Charts.Add(ChartType.Line, 0, 0, 30, 10);
var 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";
NSeries AspSeries = ActualChart.NSeries;
int SerieCount = AspSeries.Add("DataSheet!A1:A15", true);
ASeries 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";
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.IsLegendShown = false;
AsposeBook.Save("ejemplo.xlsx", FileFormatType.Excel2007Xlsx);
This message was posted using Aspose.Live 2 Forum