| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 chart gridline color using vba
Hello,
i want to apply a themecolor to a chart gridline using vba. I can apply normal colors (RGB, index) but not the theme color. Any idea? thx. berg |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel 2007 chart gridline color using vba
Hi,
Here are the various ways fo changing the colour. With ActiveChart With .Axes(xlValue, xlPrimary) If .HasMajorGridlines Then With .MajorGridlines .Border.ColorIndex = 5 'set color to blue .Border.Color = RGB(0, 255, 0) ' green .Format.Line.ForeColor.ObjectThemeColor = msoThemeColorAccent2 End With End If End With End With Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info wrote in message ... Hello, i want to apply a themecolor to a chart gridline using vba. I can apply normal colors (RGB, index) but not the theme color. Any idea? thx. berg |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel 2007 chart gridline color using vba
On 16 Dez., 14:24, "Andy Pope" wrote:
Hi, Here are the various ways fo changing the colour. * * With ActiveChart * * * * With .Axes(xlValue, xlPrimary) * * * * * * If .HasMajorGridlines Then * * * * * * * * With .MajorGridlines * * * * * * * * * * .Border.ColorIndex = 5 * *'set color to blue * * * * * * * * * * .Border.Color = RGB(0, 255, 0) ' green * * * * * * * * * * .Format.Line.ForeColor.ObjectThemeColor = msoThemeColorAccent2 * * * * * * * * End With * * * * * * End If * * * * End With * * End With Cheers Andy -- Andy Pope, Microsoft MVP - wrote in message ... Hello, i want to apply a themecolor to a chart gridline using vba. I can apply normal colors (RGB, index) but not the theme color. Any idea? thx. berg Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a gridline in an excel chart with a custom value? | Charts and Charting in Excel | |||
| How do I print selected gridline color in Excel? | Excel Discussion (Misc queries) | |||
| Color of a specific gridline | Charts and Charting in Excel | |||
| Change default gridline color in Excel 2007 | Excel Discussion (Misc queries) | |||
| Different gridline color in the same page | New Users to Excel | |||
Hybrid Mode
