Excel 2007 charting errors with pivot tables
 

With Excel 2007 if I have a pivot chart set up using an olap data source with
4 Values (measures) which are the row values and each being graphed as a
separate line in a line graph - lets just say they are A, B, C, D.

If those items are listed in the Values box on the bottom right of the pivot
table fields list window as C, A, B, D when I hover over the legend for any
of those in the actual graph it will display the wrong one on the hover over.
If I hover over the first item in the legend "A" it will show me the hover
over details for the first item in the values box "C".

Not only that , but even worse it was displaying incorrect values in the
graph. If I resorted the values inside the "Values" box in the bottom right
of the Pivottable field list window it seemed to correct them, but it all
seems to be acting up.

I have a screen shot I could take of this if it will capture the hover over
and I could try to recreate the wrong values.

Has anyone seen this before? I have extensive experience with pivot
tables/olap and have never seen anything like this in prior versions.