Chart Legend Sorting

I have a chart where I need to sort the legend so the colors appear in the
same order as the colors on the chart. It appears the order the legend
labels appear in is fairly random. To get around this we have added a custom
image below the chart with the colors and label order we need to have,
however this does cause some other issues. Is there a method to what order
the legend labels will appear?
ThanksYou might try something along these lines:
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx.
--
Michael
"Monte" wrote:
> I have a chart where I need to sort the legend so the colors appear in the
> same order as the colors on the chart. It appears the order the legend
> labels appear in is fairly random. To get around this we have added a custom
> image below the chart with the colors and label order we need to have,
> however this does cause some other issues. Is there a method to what order
> the legend labels will appear?
> Thanks