Hi,
I want to create a chart that is based on a query, using Access 2016's more modern looking charts. (it works with the ms graph chart, but those look very ugly and outdated.)
For many hours I tried, but I cant find a solution:
the chart is ignoring decimal numbers and rounds everything below 1 down to 0. In the query itself all looks nice. I also tried various field types like double, single, decimal, text...nothing works.
Looked XY times at all settings but cant find something.
My data for the chart is dates and a value between 0 and 1. Values like 0,3 or 0,55 0,9 etc.
But the chart is just showing 0, 0 ,0 for those.
Does somebody know how to fix that?