Hi,
I am using MSO charts. and i am trying to make the excel data sheet cell as "percentage" instead of "general" which is by default.
The solution which you provided shows the
chartObj.ValueAxis.NumberFormat = "0%"
But when we check the data in excel sheet it is like ".6", ".7" But we wants these values to be like "60%","70%".In excel sheet if we put data like ".6" , ".7" and then convert the cell type as Percentage. It will automatically convert them into "60%","70%". I need same kind of functionality. Instead of setting the tick lavel value as Percentage.
Please let me know how we can achieve this.
Thanks,
Amit
Hi Amit,
I have worked over the requirements shared by you. Can you please try using the following option on your end.
chartObj.ValueAxis.NumberFormat = "0.0%"
Please share, if I may help you further in this regard.
Many Thanks,
Hi,
Thanks for your response.
The solution which you provided shows the value axis in "%" but i am looking to change the data in excel sheet. It should change the data in the excel sheet not only on value axis.
In your solution when we check the data in excel sheet it is like ".6", ".7" But we wants these values to be like "60%","70%".In excel sheet if we put data like ".6" , ".7" and then convert the cell type as Percentage. It will automatically convert them into "60%","70%". I need same kind of functionality. Instead of setting the tick lavel value as Percentage.
Hi Amit,
I have observed your requirement in detail and like to share that the feature for setting the number format for chart data cells is not available in Aspose.Slides charts at the moment. The only option that is available presently is to set the TickLabel number format your self as shared by me in my former post. I have created an issue with ID SLIDESNET-33823 in our issue tracking system as new feature request so that our development team may investigate the possibility of implementing the desired feature. This thread has been linked with the issue so that you may be automatically notified once the issue will be resolved.
We are sorry for your inconvenience,
Hi,
Any updates on the issue? Can you please provide me the ETA for the issue?
Thanks,
Amit
Hi Amit,
I have verified from our issue tracking system and regret to share that issue has not yet been scheduled for investigation. However, I have requested our development team to schedule the issue for investigation. I will share the further information with you as soon as it will be shared by our development team.
Many Thanks,
The issues you have found earlier (filed as SLIDESNET-33823) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.