I have a strange problem, I hope you can help me with.
I have created a workbook with a query and a graph (column) on that query. The strange thing is, that the Y-axis for the graph shows duplicate values: 1,1,2,2,3,3 with the column for the value 3 going all the way to the top. I have tried inserting a standard Excel graph on the query table, the same thing happens.
The query itself is very simple. 3 restricted KFs in the rows and Calyear 4 years back in the columns. As only data for this year exists, the report shows 1 column and 3 rows.
Hope you can help