I spotted the problem:
In Garry's example there are 6 series. The first 5 are assigned to Y1 and the last is assigned to Y2. Everything works fine in "preview mode". But any action that causes the "design tab" to draw results in CR telling our chart engine that there are only FOUR series of data (the 4 'fake' series that always show up in a chart in design mode: WA, CA, BC, etc.).
So now our chart engine thinks that it is being told to draw a dual-y chart with 4 series of data. But... it looks and sees that the four series it knows about (first 4 series) are all assigned to Y1, and there are NO series assigned to Y2. It considers this an 'error' since this is not a valid dual-y chart if there is no data to chart on Y2.
It tries to resolve this error by arbitrarily putting 1/2 of the series it knows about onto Y2. So it ends up setting series 1 and 3 on Y2.
The 'ultimate' solution would probably be for CR to allow users to set an arbitrary number of series in DESIGN mode instead of always using exactly 4.
But for now, I've tweaked the engine to fix this problem by telling it that having all series on Y1 is NOT an error (so it doesn't go and arbitrarily put series on Y2). This is not 'perfect' since it creates a weird DESIGN mode chart that has a Y2 axis with no valid range and also the "Assign series to Axis" dialog in DESIGN mode won't operate (it never expected to see a case with all series on Y1 and none on Y2). But it works flawlessy in generating a report and I think will give the results that everyone is really after.
I'll submit this code change to CR for inclusion in a future 'hot fix' for CR9 and it should be part of CR10 when it ships. I also added it to our
CRChart replacement library for CR 8, 8.5 and 9 which will be available directly from us in August.
Regards,
-Dan @ 3D
Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.
