Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Nou pe simpatie:
Laura Petrei pe Simpatie

Femeie
24 ani
Braila
cauta Barbat
27 - 65 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Center Chart Title [VBA]

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 960

Source (post #7)
https://www.ozgrid.com/forum/forum/help ... t-with-vba

Adapted to work on selected chart, regardless of title text:

Sub CenterChartTitle()
Dim titleTop As Single

With ActiveChart
With ActiveChart.ChartTitle
titleTop = .Top
End With
.SetElement (msoElementChartTitleCenteredOverlay)
.ChartTitle.Top = titleTop
End With
End Sub

Pagini: 1

Mergi la