Posts by ongbey

    Re: Formating chart object (plot) in VBA using 2010 Excel macro


    Hi
    I have also a question about formating chart object as follows;


    I recorded macro with mouse gesture, but it doesn't works. I cannot understand why ? This macro recorded by excel 2013 but it does not works.
    Could you please help me ?


    ActiveSheet.ChartObjects("Grafik 1").Activate
    ActiveChart.Axes(xlCategory).AxisTitle.Select
    ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "Sales)"
    Selection.Format.TextFrame2.TextRange.Characters.Text = "Sales)"
    With Selection.Format.TextFrame2.TextRange.Characters(1, 6).ParagraphFormat
    .TextDirection = msoTextDirectionLeftToRight
    .Alignment = msoAlignCenter
    End With
    With Selection.Format.TextFrame2.TextRange.Characters(1, 6).Font
    .BaselineOffset = 0
    .Bold = msoTrue
    .NameComplexScript = "Arial"
    .NameFarEast = "Arial"
    .Fill.Visible = msoTrue
    .Fill.ForeColor.RGB = RGB(0, 0, 0)
    .Fill.Transparency = 0
    .Fill.Solid
    .Size = 9
    .Italic = msoFalse
    .Kerning = 12
    .Name = "Arial"
    .UnderlineStyle = msoNoUnderline
    .Strike = msoNoStrike
    End With
    Range("N49").Select