I need to show the value axis of a chart in percentages. There is no current way that I have seen that this can be done. In Aspose.Cells you can do this with the TickLabel of the ValueAxis object. Here is how to do it in Cells:
Hi Dustin,
Hi Dustin,
I have observed the requirements shared by you and like to share that the feature that you are looking for is currently unavailable in Aspose.Slides. An issue with ID SLIDESNET-33122 has been created in our issue tracking system as new feature request to provide this feature. This thread has been linked with the issue so that you may be automatically notified once the issue is resolved. At the moment, only setting DiplayUntit property is available for setting axis values.
chart.ValueAxis.DisplayUnit=DisplayUnitType.None;
We are sorry for your inconvenience,
Is there a time frame for when it will be completed?
Hi Dustin,
Is there an update on this issue?
Unfortunately the moment a chart data is being touched the formatting on value axis is set to general (not preserving the format set in the template), and not being able to modify it later (via code) does not produce a final presentation.
Quick response will be appreciated.
Thanks
Hi Dustin,
Hello Mudassir,
Hi Dustin,
Hello Mudassir,
Hi Dustin,
It has almost been another month is there any update on this issue yet?
Hi Dustin,
Hi Dustin,
chart.ValueAxis.DisplayUnit = Aspose.Slides .Pptx .Charts.DisplayUnitType.None;chart.ValueAxis.NumberFormat = “0.0%”;chart.ValueAxis.SourceLinked = false;
The issues you have found earlier (filed as SLIDESNET-33122) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
Hello.
…but I have a problem because the axis gets displayed correctly as a percentage but the values on top of the bars of my chart are not percentages (I get 0.3 instead of 30%). I’ve tried this but it didn’t help :chart.ValueAxis.DisplayUnit = Aspose.Slides .Pptx .Charts.DisplayUnitType.Hundreds;chart.ValueAxis.NumberFormat = “0%”;chart.ValueAxis.SourceLinked = false;
lSeries.Labels.ShowValue = true;
lSeries.Labels.NumberFormat = “0%”;
lSeries.Labels.ShowPercentage = true;
lSeries.Labels.LinkedSource = false;
There is no DisplayUnit in there to modify.
If I change the 1st line of the code to :
chart.ValueAxis.DisplayUnit = Aspose.Slides .Pptx .Charts.DisplayUnitType.None;
The values of the bars are correct and the axis values are wrong…
Any ideas on what I can do?
Hi,
OK. I have solved this problem using your fix.
Isn’t this line supposed to show/hide the percentage sign on the value of the label that is placed on top of the bars of a bar chart?
Hi,