I have a one XY- chart in one report that in row source:
"TRANSFORM Sum(Dispes.Move) AS SMove SELECT Dispes.Date FROM Dispes GROUP BY Dispes.Date PIVOT Dispes.Depth;"
in this way y-axis assigns Move field and X-axis assigns Depth field. But I want to have a a chart Grouped by Date And PIVOT with Depth fieldes, but with X-axis assigns Move field and Y-axis assigns Depth field .how I does this?