Skip to Content
Former Member
Nov 09, 2006 at 10:19 AM

BEx graph, duplicate values on Y-axis


Hi guys

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