Macros for graph formatting

[Weissme]

Hi,

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

Thanks!

[Jon Peltier]

Is this what you were trying to get:

ActiveChart.SeriesCollection(1).Points(3).Select
With Selection.Border
.Weight = xlThin
.LineStyle = xlAutomatic
End With
Selection.Shadow = False
Selection.InvertIfNegative = False
Selection.Fill.Patterned Pattern:=msoPattern75Percent
With Selection
.Fill.Visible = True
.Fill.ForeColor.SchemeColor = 17
.Fill.BackColor.SchemeColor = 2
End With

Of course, you wouldn't use the code like above. This is streamlined by
leaving out the select/selection and the defaults:

With ActiveChart.SeriesCollection(1).Points(3)
With .Fill
.Patterned Pattern:=msoPattern75Percent
.Visible = True
.ForeColor.SchemeColor = 17
.BackColor.SchemeColor = 2
End With
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Weissme" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I am generating a bar graph that projects future values for years
> 2007-2011. I want the future value bars to be shaded 75%. I tried to
> record a macro to do this (basically record macro-> select individual
> bar -> right click -> etc etc to change the bar shading to 75%). But I
> can't seem to get this to work. Maybe it's a relative reference
> problem? Any help would be appreciated. Is what I'm trying to do even
> possible with macros?
>
> Thanks!
>
>
> --
> Weissme
> ------------------------------------------------------------------------
> Weissme's Profile:
> http://www.excelforum.com/member.php...o&userid=34044
> View this thread: http://www.excelforum.com/showthread...hreadid=538051
>