Legend not corresponding to Graph?

Hi All,

I am working with a pivot table and using a pivot chart from the data. The chart I need to use is a horizontal colour coded bar chart. The chart and labels accurately show the data. The problem is with the legend. I will give a simple example.

Chart Legend
A - 30% D
B - 73% C
C - 15% B
D - 29% A


On the example above, treat Chart and Legend as different rows.

The colours on the chart are matched with the colours on the legend correctly, so A would be for example red on both the chart bar and the legend, but it looks confusing as the legend is in an opposite position to the bar it refers to.

I am using excel 2007 and I need to keep the order of the chart bars as they are following legacy printed charts, I just need the legend to work correctly.

Any ideas?