Excel Tutorials | Chart Macro Code

Add Chart Title

Sub AddChartTitle() Dim i As Variant i = InputBox(“Please enter your chart title”, “Chart Title”) On Error GoTo Last ActiveChart.SetElement (msoElementChartTitleAboveChart) ActiveChart.ChartTitle.Text = i Last:

Read More »

Paste Chart as an Image

Sub ConvertChartToPicture() ActiveChart.ChartArea.Copy ActiveSheet.Range(“A1”).Select ActiveSheet.Pictures.Paste.Select End Sub Paste Chart as an Image VBA code: This code will help you to convert your chart into an

Read More »

Change Chart Type

Sub ChangeChartType() ActiveChart.ChartType = xlColumnClustered End Sub This code will help you to convert chart type without using chart options from the tab. All you

Read More »