nagovind
Member
In an excel sheet using VBA i have generated xy coordinates
There are 50K points
I'm using array to store the vlaues
XY scatter chart with LOG-LOG scale is used
Issue is...i need to round up the "y" coordinate to 3 decimal places for other calculation purpose
But if i declare the array as VARIANT then if i store the rounded value in to the array of variant type it is not at all rounded/ truncated it is showing some value in the cell even after 3rd decimal places
whilst if i declare the array as DOUBLE then i store the rounded value in to the array of DOUBLE type then it is 100% perfect
So how to resolve this
Main issue is if i declare the array variable as DOUBLE then UNUSED array values are shown as '0' zero this has the issue in CHART and there is a warning message that Zero and negative values are not used in LOG-LOG sheet
Please help to have a solution
There are 50K points
I'm using array to store the vlaues
XY scatter chart with LOG-LOG scale is used
Issue is...i need to round up the "y" coordinate to 3 decimal places for other calculation purpose
But if i declare the array as VARIANT then if i store the rounded value in to the array of variant type it is not at all rounded/ truncated it is showing some value in the cell even after 3rd decimal places
whilst if i declare the array as DOUBLE then i store the rounded value in to the array of DOUBLE type then it is 100% perfect
So how to resolve this
Main issue is if i declare the array variable as DOUBLE then UNUSED array values are shown as '0' zero this has the issue in CHART and there is a warning message that Zero and negative values are not used in LOG-LOG sheet
Please help to have a solution