Qamar Iskandar
New Member
- Joined
- Jun 20, 2014
- Messages
- 4
Hi everyone
I've created a bar chart using a data from the cells.
When the cell show 18.96 on the data label it's also show 18.96 which is fine with me because that is what what it to show on the chart.
But when the value is 55, 60 or even 100 it will show 55. , 60. and 100. on the data label. For the moment i'm using custom data label that is 0.##;;
Can anyone help me with the custom data label so it will show two decimals point when there is value after it and it will hide the '.' when the value is 00 after the decimals.
I'm using MS office 2010.
Thank you in advance for the help.
I've created a bar chart using a data from the cells.
When the cell show 18.96 on the data label it's also show 18.96 which is fine with me because that is what what it to show on the chart.
But when the value is 55, 60 or even 100 it will show 55. , 60. and 100. on the data label. For the moment i'm using custom data label that is 0.##;;
Can anyone help me with the custom data label so it will show two decimals point when there is value after it and it will hide the '.' when the value is 00 after the decimals.
I'm using MS office 2010.
Thank you in advance for the help.
