Thank you very much for the presentation. I tried to create similar chart with my own data but I could not proceed in "Format Code" under Number where the triangle is not coming after pressing Alt 30 & 31. Is there any other alternate for this please?
Please help...I'm using data labels..in label options I'm selecting values from cells..in my data i have zeros and 0.2.. 0.9.. 0.6... 0.3...i want to hide zeros only .. how to do it?
Hi Hasaan, I would be Grateful if You respond to My question. • In a Column Chart, I connected the Data Labels to a range . . will Custom Formatting not work in this situation? Please advise. Thank You!
Hey Hasaan, thanks for this video. One question: Is it possible to custom the [blue] or [red] with some RGB or HEX color? I tried with [green] and it works, but I didn't like the default green...
@@maynwayaung2835 In excel, select "Insert > Symbols". There select the Font "Arial" and Subset "Geometric Shapes". There you have the required up and down triangles. Copy paste in excel first and from there again copy paste to your chart area
@@HasaanFazal Hi Hasan, I'm using Excel in 365, firstly, as some have mentioned, the Alt key in doesn't work. But when got around it by writing the code in excel using symbols and copying and pasting, when clicked add, nothing changes. Any help to get this running? Thanks!
Brilliant as usual Hasaan - thank you.
Glad you liked it :)
Thanks for the great video! Any way to make this formatting apply to Labels that are selected from other Cell Values???
Thank you very much for the presentation. I tried to create similar chart with my own data but I could not proceed in "Format Code" under Number where the triangle is not coming after pressing Alt 30 & 31. Is there any other alternate for this please?
How to do it in Excel 2016? this code is not working for me
Please help...I'm using data labels..in label options I'm selecting values from cells..in my data i have zeros and 0.2.. 0.9.. 0.6... 0.3...i want to hide zeros only .. how to do it?
Hi Hasaan,
I would be Grateful if You respond to My question.
• In a Column Chart, I connected the Data Labels to a range . . will Custom Formatting not work in this situation?
Please advise.
Thank You!
Very clear
when I click add, no response
Hey Hasaan, thanks for this video. One question: Is it possible to custom the [blue] or [red] with some RGB or HEX color? I tried with [green] and it works, but I didn't like the default green...
How to do change color to red any label values that contains text of --> 2019 Q3 ???
Hello you have mass mail template ?
Can work on that.
Yesss. Pls sir
you are a brilliant man in the world
appreciate your kind words
I found an alternate way and achieved the desired goal
MI also can't press Alt 30. Could you share your alternate way,please ?
@@maynwayaung2835 In excel, select "Insert > Symbols". There select the Font "Arial" and Subset "Geometric Shapes". There you have the required up and down triangles. Copy paste in excel first and from there again copy paste to your chart area
@@lakshmipathiganesan6332 Thank you!
Not working, tried everything
Here to help. Let me know what have you tried already. Lets work it out together.
@@HasaanFazal Hi Hasan, I'm using Excel in 365, firstly, as some have mentioned, the Alt key in doesn't work. But when got around it by writing the code in excel using symbols and copying and pasting, when clicked add, nothing changes. Any help to get this running?
Thanks!
@@anuradhaekanayake5056 same issue, kindly your help