Changing the axes font characterstics of excel charts using vba

[aprvvsh]

Changes made to the axes scales are not reflected after running the vba code.

ActiveChart.Axes(xlValue).Select
  With Selection.Format.TextFrame2.TextRange.Font
  .BaselineOffset = 0
  .Fill.Visible = msoTrue
  .Fill.ForeColor.ObjectThemeColor = msoThemeColorText1
  .Fill.ForeColor.TintAndShade = 0
  .Fill.ForeColor.Brightness = 0
  .Fill.Transparency = 0
  .Fill.Solid
  End With

 

[Luke M]

Not sure what your question is...

 

[aprvvsh]

Not sure what your question is...

I want to make some changes in the text font color of the axis scale values which is by default grey. I tried changing the color using a macro, but it didn't work out.

 

[Luke M]

Thanks, that clarifies a lot. Code line would be

ActiveChart.Axes(xlValue).TickLabels.Font.Color = RGB(120, 120, 120) 'Pick whatever RGB values you want