MS graph and Color palatte problem(executing VBA Code)

Hi All,

Here I?m attaching ?stackProb.zip? file. This file consisting of stackProb.ppt and stackProb.bas(macro) file. I?m having below issues regarding this presentation

• ?shpLeagend1? object set with 5732351(RGB) color value. The same color value is used to display stack bar which is displaying ?58? but it is showing different color. How to set this color value correctly in MS graph so that it will work same as shape object color?
• ?42? is displaying in black font color on yellow stack bar, how to change ?42? font color to red? But it shouldn?t effect ?58? (display in black color).
• ?chartProxy.PlotArea().Fill().ForeColor().SchemeColor = 20? is showing gray color background(MS graph) in power point 2000 but it is not the same in case of power point 2003. How to fix the problem so that it will show gray color correctly in both power point 2000 and 2003?

Thanks in advance.

Regards,
Sharath.