graph

[geebee]

I have a graph with a primary and secondary axis. It has 3 lines. Ever
since I added the 3rd line, the 3rd line is not plotting correctly. There is
a data table at the bottom of the graph, so I know the data is right, but the
line is wrong place. What is going on here?

graph source:
TRANSFORM
Sum(resolvedno_vs_noofCACScalls_betweenpopenterdtandresolveddt.[SumOfCOUNT( *
)]) AS [SumOfSumOfCOUNT( * )]
SELECT [ResolvedStatus] & " " & IIf([line]="line1","call
count",IIf([line]="line2","resolved count","resolved, no calls")) AS Expr1
FROM resolvedno_vs_noofCACScalls_betweenpopenterdtandresolveddt
GROUP BY [ResolvedStatus] & " " & IIf([line]="line1","call
count",IIf([line]="line2","resolved count","resolved, no calls")),
resolvedno_vs_noofCACScalls_betweenpopenterdtandresolveddt.line,
resolvedno_vs_noofCACScalls_betweenpopenterdtandresolveddt.line
PIVOT Format([ResolvedDt],'mm/dd');


Thanks in advance,
geebee