We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

132729 Sep 18,2017 10:07 AM Oct 3,2017 09:59 AM ASP.NET MVC 5
loading
Tags: XlsIO
ayben
Asked On September 18, 2017 10:07 AM

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 [Syncfusion]
Replied On September 20, 2017 01:03 PM

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. 
 
  
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
Replied On September 22, 2017 10:04 AM

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 [Syncfusion]
Replied On September 25, 2017 08:41 AM

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: 
 
Please let us know if you have any concern. 
 
Regards, 
Sridhar. 


ayben
Replied On October 2, 2017 05:22 AM

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 [Syncfusion]
Replied On October 3, 2017 09:59 AM

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. 
  
  
Please let us know if you have any concern. 
  
Regards, 
Sridhar. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;