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