Render bubble using absolute size value but having original size value in the data

Aspose.Cells Product Family
1

Hi Team,

Could you please let us know the feasibility of rendering the bubble using absolute value but in the data I still need to have the original value which is of negative number.

For example in the below image, the cell B6 has 4.6%, If I provide it as -4.6%, bubble will not be rendered. So I need to render the bubble as 4.6% but in the data, it needs to be with negative number as -4.6%.

image.png (39.5 KB)

So if you see the below image, where I have made the B6 cell as -4.6% and the bubble got disappeared.

image.png (39.2 KB)

Could you please let us know if there is any way to refer the absolute value from the data to render the bubble pls ?

Thanks,
Thilak

2

@Thilakbabu,

Thanks for the screenshots and details.

Aspose.Cells follows MS Excel standards and specifications when creating or manipulating charts. How could you accomplish your task and create such a bubble chart in MS Excel manually. Could you please provide a sample file having your expected bubble chart (which is rendered with bubble according to 4.6% but in the source data is negative number (e.g., -4.6%)) in it. We will evaluate and check on how to do it via Aspose.Cells APIs.

3

Hi @amjad_sahi ,

Thanks for the reply.

No, I have not tried manually in Microsoft Excel. But wanted to check with Aspose once if any such option is available.
So, as such it’s not possible from Aspose, right?
I will further check with Microsoft once if they have any options to do.

Thanks.

4

@Thilakbabu
By creating sample files for testing, we found that Excel cannot display bubble charts when the value is negative. Please refer to the attachment. sample.zip (20.6 KB)

If you still have any questions, please provide us with your sample files and test code, and we will check them soon.