Hi,

I am generating a bar graph that projects future values for year
2007-2011. I want the future value bars to be shaded 75%. I tried t
record a macro to do this (basically record macro- select individua
bar - right click - etc etc to change the bar shading to 75%). But
can't seem to get this to work. Maybe it's a relative referenc
problem? Any help would be appreciated. Is what I'm trying to do eve
possible with macros?

Thanks

--
Weissm
-----------------------------------------------------------------------
Weissme's Profile: http://www.excelforum.com/member.php...fo&userid=3404
View this thread: http://www.excelforum.com/showthread.php?threadid=53805