dragonturtle
Programmer
Hi,
I have a chart that displays results from various measurements that have different ranges and decimal precisions. For example, some measures will have numbers between 10 - 20,000, others will be small numbers between 0.031 - 0.065.
The chart does a decent job estimating ranges for display, but I'm having problem with precision. In the above examples, the Y-axis will display 0.0, 0.0, 0.0, 0.1, 0.1. Even if all the numbers are 3 decimals, the chart only shows 1 decimal place! Is there any way to dynamically alter axis decimal precision by formula? Or some other means?
Because I can't predict what ranges of numbers the measurements will record (it's an ongoing project), I can't just set a range and precision during chart creation.
I have a chart that displays results from various measurements that have different ranges and decimal precisions. For example, some measures will have numbers between 10 - 20,000, others will be small numbers between 0.031 - 0.065.
The chart does a decent job estimating ranges for display, but I'm having problem with precision. In the above examples, the Y-axis will display 0.0, 0.0, 0.0, 0.1, 0.1. Even if all the numbers are 3 decimals, the chart only shows 1 decimal place! Is there any way to dynamically alter axis decimal precision by formula? Or some other means?
Because I can't predict what ranges of numbers the measurements will record (it's an ongoing project), I can't just set a range and precision during chart creation.