Making bulk change to chart type in workbook pages

Question

I have a workbook of line graphs created with "Line with Marker" selection.&nbsp; I need to change all 50+ line&nbsp; graphs to just Line.&nbsp; Is there an option to change all workbook pages at same time OR must I change each page one-by-one.&nbsp; Thanks,

hansvogelaar · Answer

gflory&nbsp;
Run this short macro:
Sub ModifyCharts()
    Dim w As Worksheet
    Dim c As ChartObject
    For Each w In Worksheets
        For Each c In w.ChartObjects
            c.Chart.ChartType = xlLine
        Next c
    Next w
End Sub

Forum Discussion

Making bulk change to chart type in workbook pages

1 Reply

Resources