I have a plotted a periodic 100% stacked column chart with 6 data rows
(meaning 6 components of data for each period). I have a secondary periodic
data with 5 compenents that I have plotted on secondary axis. Both the data
are in per cents. I have equalized the scale on both axes.

The problem is that the lines plotted on secondary axes are not plotted in
accordance with the values. For example, one data row with values 2% to 6% is
appearing near 100% line (100% on both axes are aligned across the same
line). Even strange is that when I change the "Series Order" of the same lime
to move it up, it'd appear correctly but then the other lines would appear
against wrong values.

Primary Data
APR-07 MAY-07 JUN-07 JUL-07 AUG-07 SEP-07 OCT-07
29% 28% 23% 15% -30% 13% 19%
55% 40% 44% 50% 83% 51% 46%
7% 6% 6% 13% 15% 11% 10%
4% 20% 19% 15% 22% 18% 15%
2% 3% 2% 1% 7% 4% 6%
4% 4% 5% 6% 4% 5% 5%

Secondary Data
APR-07 MAY-07 JUN-07 JUL-07 AUG-07 SEP-07 OCT-07
24% 32% 43% 53% 61% 43% 35%
41% 26% 23% 24% 96% 37% 36%
15% 19% 17% 8% -95% 2% 13%
15% 16% 11% 10% 27% 14% 10%
2% 3% 3% 2% 6% 5% 5%

Please help.
--
Thanx & regards,
Asif