Free Support Forum - aspose.com

Problem with explanatory notes of bubble chart

Aspose.Cells Product Family
#1

Dear Customer support

Hi.I have 2 questions about bubble charts.
(I am Japanese.Sorry for my English level.)

(Q1)
I have a problem to create bubble chart using Aspose cells through C#.Net. I can not correctory show explanatory notes up on the grpaph.(Please see attached file) I am trying to make a explanatory notes as "Acompany" but "1" shows up instead of "Acompany".

I wrote codes as below ,
//Set properties of nseries
chart.NSeries[0].Name = cells["C1"].Value.ToString();
chart.NSeries[0].XValues = "B24";
chart.NSeries[0].Values = "B26";
chart.NSeries[0].BubbleSizes = "C2";

(Q2)
How to put bublle to the center of the chart?

Thank you,
Kaz

This message was posted using Page2Forum (attachment) from bubble chart center - Aspose Search Results - Aspose.com
#2

Dear Kaz,

I am moving your inquiry in Aspose.Cells forum where our related support developers will help you.

Have a good time.

#3

Hi Kaz,

(Q1)

We find the template chart is very strange. You have to add some following codes to make the legend became "Acompany".

chart.NSeries.IsColorVaried = false;
chart.NSeries[0].Points.Clear();

Please do not select "Vary color by point" when you format the series.If the option is true, the legend will be the index of the chart point.

(Q2),

We do not support to set the scale of the category axis of bubble chart. We will support it soon.Thanks for you patience.

#4

Hi Kaz,

Please try this fix with the following codes:

Chart chart = workbook.Worksheets[0].Charts[0];
chart.NSeries[0].Name = "=C1";
chart.NSeries[0].XValues = "B24";
chart.NSeries[0].Values = "B26";
chart.NSeries[0].BubbleSizes = "C2";

chart.CategoryAxis.MinValue = 0;
chart.CategoryAxis.MaxValue = 2;
chart.CategoryAxis.MajorUnit = 1;
chart.CategoryAxis.MinorUnit = 1;
chart.NSeries.IsColorVaried = false;
chart.NSeries[0].Points.Clear();

You have to resize the legend because the legend is defined in the template file.

#5

Hi Zhang

I appriciage your quik answer.
I have a one more question about bubble chart.How can I make a color to legend. If I select "vary color by point", I can not select the color.
Is that possible making color bubble charts with legend by ASPOSE.

Thank you
Kaz