VBA for Excel 2007 tutorial-chart area gradient style


Chart area gradient style

In this VBA code example, you will learn VBA code to apply the gradient style of chart area. To apply a gradient style to a chart area, you can use the PresetGradient() method of the Fill object. This method has the following prototype:

Fill.PresetGradient(Gradent_Style, Variant, Gradient_Type)

-The Gradient_Style argument represents the style of gradient. Its value can be msoGradientDiagonalDown, msoGradientDiagonalUp, msoGradientMixed, msoGradientFromCenter,msoGradientFromTitle, msoGradientFromCorner,etc.
-The Variant argument represents the variance of gradient. Its value can be from 1 to 4.
-Gradient_Type represents the type of gradient. It can be msoGradientBrass, msoGradientCalmWater, msoGradientEarlySunset, msoGradientDayBreak, msoGradientGold, msoGradientSilver, msoGradientFog, msoGradientFire,etc.


VBA for Excel: VBA example code to format chart area with gradient style

To run this VBA example code, you can copy and paste the VBA code below in to the block of Worksheet_Activate() procedure. To open this block, double-click the current worksheet, then in the objects dropdown list select Sheet1 and in events list select Activate.



VBA code for this example:


Option Explicit
Private Sub Worksheet_Activate()
   
    Dim i As Integer
    'Fill Source data
    For i = 1 To 10
        Randomize
         Range("A" & i) = Int(100 * Rnd) + 1
         Range("B" & i) = Int(100 * Rnd) + 1
    Next
 
    'Select the data source
    Range("A1:B10").Select
    'Create a clusted column chart
    ActiveSheet.Shapes.AddChart xl3DColumn, 10, 180
    ActiveSheet.Shapes(1).Select
    ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$B$10"), PlotBy:=xlColumns
   
   'Fill the chart area with a gradient style
    ActiveChart.ChartArea.Format.Fill.PresetGradient _
    msoGradientHorizontal, 2, msoGradientEarlySunset

 
End Sub

Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.