How to format selected charts using vba in excel

preview_player
Показать описание
Sub FormatSelectedCharts()

Dim ChtObj As ChartObject

For Each ChtObj In Selection

With ChtObj.Chart
'.SeriesCollection(1).MarkerBackgroundColor = RGB(204, 102, 255)
.Axes(xlValue).HasMajorGridlines = False
End With

Next

End Sub
Рекомендации по теме
Комментарии
Автор

My Big thanks to such nice videos. I am trying to do chart title formatting in all charts in worksheet. Please could you share script for selecting all charts in worksheet.

paraputhan
Автор

Teria como disparar a macro automaticamente após selecionar o um gráfico somente?

carlosrocha