Bubble chart Excel export: Data gets scrumbled while exporting data to Excel

[ayben]

Hi,

When I try to export a bubble chart data to an Excel spreadsheet, there are several errors:

1. The data series for X and Y axis and the bubble size data seems to be shifted when data is exported to Excel. As a result, Axis X is shfted to Axis Y, Data in Axis Y is shifted to the bubble data,and so on.

2. The colors of the bubbles in Excel are all the same and different than the ones on the chart objects.

How can we fix theses problems?

Thanks in advance.

Ayben.

[Saravana Kumar Kanagavel]

Hi Ayben, 

 

Thanks for contacting Syncfusion Support. 

 

We have analyzed your queries and please find the response below for your queries. 

 

Query 1: The data series for X and Y axis and the bubble size data seems to be shifted when data is exported to Excel. As a result, Axis X is shfted to Axis Y, Data in Axis Y is shifted to the bubble data,and so on. 

 

We have tried to reproduce the reported issue but unfortunately not able to reproduce the reported issue at out end.  

 

So we have prepared the sample for your reference and attached in the below location. 

 

Sample Link : https://www.syncfusion.com/downloads/support/forum/132729/ze/WebApplication2399487166 

  

Query 2 : The colors of the bubbles in Excel are all the same and different than the ones on the chart objects. 

 

If you wish to change the color for the series , then please refer the code example below 

 

[C#] 

ChartProperties obj = ConvertChartObject(ChartModel); 

obj.Series[0].Fill = "#4286F4"; 

 

In the above code, we are changing the series color by using “Fill” property in chart. 

 

Please find screenshot of excel export from the below 

 

  

 

If you still face any concern , kindly revert us with issue reproducing sample or modified the attached sample to provide the exact solution sooner. 

 

Please let us know if you have any concern on this. 

 

Regards, 

Saravana Kumar K 

[ayben]

Hi,

Thanks  for your answer.  May I ask you a few  questions?  I  send  my excel output picture to you. picture link("https://i.hizliresim.com/7yoAoP.jpg")

1. How can I occur this  buble chart data an Excel?

2. How can I transfer to excel in this graphic as picture? 

3. How can I occur this buble chart for use XlslO library?

Thanks in advance 

Ayben 

[Sridhar Sukumar]

Hi Ayben, 

 

Thank you updating us. 

 

Your requirement cannot be achieved by creating bubble chart in Excel. As per MS Excel behavior, the bubble chart categories axis should be numeric axis. But in the shared picture, the bubble chart category axis is text axis. 

 

However, we have prepared a workaround sample by creating Line with Marker chart to achieve your requirement. The sample can be downloaded from the following link. 

 

Sample link: 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/BubbleChart194254923.zip 

 

Please let us know if you have any concern. 

 

Regards, 

Sridhar. 

[ayben]

Hi,

Thanks  for your answer. I want to import the graphic as an image in Excel. How can I  do that ?

Thanks in advance.

Ayben.

[Sridhar Sukumar]

Hi Ayben, 

  

Thank you for updating us. 

  

The images can be inserted into worksheet using Pictures.AddPicture() method. Please refer the following UG documentation link to achieve your requirement. 

  

UG Documentation: https://help.syncfusion.com/file-formats/xlsio/working-with-pictures 

  

Please let us know if you have any concern. 

  

Regards, 

Sridhar.