Order problem with MS graph in a 2 axis chart

[robjam7]

I have created a data set in a query which I have displayed in a form. The graph appears but the data is in a different order.
The other problem is that because it is a bar and line graph on two axis, iam getting lines where i want bars and visa versa.
Can I rectify these problems with code? If so where and how?

The data is formatted like this

Desc Period1 Period2 Period3 Period4
Total A 10 11 12 14
Total B 9 20 23 5
Total C 21 15 17 25
% A 75% 61% 74% 77%
% B 73% 63% 84% 37%
% C 71% 68% 86% 47%

I am Looking for the Totals on the first Y axis, and the %'s on the Second Y axis.

Thanks In advance.

Robjam1