How to remove extensive decimal points in Visio

51 viewsdecimal points decimals excecssive significant figures Visio
0
0 Comments

Hi everything,

I am doing a Visio; however, the data grabbed contains  alot of useless decimal point as shown as below:

Hence, how can I remove this decimal points OR just make it to 2 decimal places?

As shown below is my syntax for the graph:

As shown below is the syntax for that greenbox

Thank you very much for your assistance and have a nice day!

Steve Purcell [SLC] [DevOps Advocate] Answered question 14 hours ago

1 Answer

1
1.69K 1 Comment

Hi Fawzan,

You can try adding a shape data filed 'Options', then 'Decimals=2' for the value.

This should display the returned value with 2 decimal places.

Thanks,

Steve

FAWZAN KHAIZURAN FAUDZI [DevOps Advocate] Edited comment 5 hours ago
FAWZAN KHAIZURAN FAUDZI [DevOps Advocate] commented

Nice!

Thank you Steve! It works on that Green Box.

However for the chart above, it still remains the same.. there is still a lot of decimal places on y axis.
* * *
This is my syntax for that chart:
——————————————————————————————————————————
Component: Trending
Parameters: 1431:[this service]
ParametersOptions: Range:DAY|NavigatorChart:False|ShowLegend:True|
Options: Decimals=2
——————————————————————————————————————————
I also tried to do like this:
——————————————————————————————————————————
Component: Trending
Parameters: 1431:[this service]
ParametersOptions: Range:DAY|NavigatorChart:False|ShowLegend:True|Decimals=2
——————————————————————————————————————————
and this:
——————————————————————————————————————————
Component: Trending
Parameters: 1431:[this service]
ParametersOptions: Range:DAY|NavigatorChart:False|ShowLegend:True|Decimals:2
——————————————————————————————————————————
However, the chart still has a lot of decimals.. haha.. might be there a specific syntax for the chart?

Thank you very much for your assistance and have a nice day!