LinkBack URL
About LinkBacks
Hi I am plotting some data and some labels are represented with less than 1%. This shows as 0% on my graph. Is it possible to show it in permilles?
Hi I am plotting some data and some labels are represented with less than 1%. This shows as 0% on my graph. Is it possible to show it in permilles?
Last edited by Frankwell; 07-31-2022 at 05:02 AM. Reason: vocabulary
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Administarive Notice:
Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings: northern hemisphere is not precise enough for this.
With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).
Thank you for helping us to help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I have attached a working example
Pleae explain the term 'promile'.
If 1 percent is 1/100, permille is 1/1000.
Another solution that would satisfy my requirements is to display 0.9% for example
'Permille' is NOT the word you used in your title or opening post!!!
It was a typo. No need to use exclamation points. In my previous reply I have explained what I meant. I have also edited the original question.
Last edited by Frankwell; 07-31-2022 at 05:04 AM.
I shall use exclamation marks if I choose! And they were perfectly apt. I wasted time Googling 'promile' in order to try and help you.
Good luck with this.
So you are not helping me because I made a mistake. "Promile" was the first translation of the word from my language that I found hence I used it. You pointed out my mistake and I corrected it. If you decide to help me I will find it really helpful. Otherwise thanks a lot and have a nice day.
Last edited by AliGW; 07-31-2022 at 06:42 AM. Reason: Insult removed from post.
I am not helping because your response was ill-mannered, not because you made a mistake.
Take more care over your titles and opening posts in future - what you say there is CRUCIAL to your helper understanding your query and being able to help you. It is far from trivial.
Maybe this:
=IF(100*A2/$L$2<1,ROUND(10*100*A2/$L$2,1)&"?",ROUND(100*A2/$L$2,1)&"%")
copied across... and use the values displayed there in your chart labels.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
This works. Thank youOriginally Posted by Glenn Kennedy
You can change the Label Options formatting category from General to Number to show decimal places in the percentages.
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks