Excel Delink Chart data, Labels and etc 1

[xlhelp]

Hello.

One can delink (or unlink) the plotted data in a chart by clicking on the series and then while in the formula bar, press F9 (or CTRL/=) and press Enter to remove links to the cells and leave absolute values in the chart for the particular series.

I am looking for an all encompassing macro to delink series, axes, labels, titles etc. for an auto-dynamic chart I have created.

Please don't go through the trouble of creating one on my account. If you have one, I would love to have it. Being lazy, I am trying to take the easy way out.

Member- AAAA Association Against Acronym Abusers

 

[SkipVought]

Hi,

For instance for each object value you want to make static...

Sub test()
    With ActiveSheet.ChartObjects(1).Chart
        .ChartTitle.Text = .ChartTitle.Text
'other go here
    End With
End Sub

Skip,

_[red][/red]

 

[xlhelp]

Dang.....so simple.

I bow to you ole Grand Master.

Member- AAAA Association Against Acronym Abusers

 

[SkipVought]

You can further automate...

Sub test()
    dim oObj as Object
    On Error Resume Next
    With ActiveSheet.ChartObjects(1).Chart
        .ChartTitle.Text = .ChartTitle.Text
'where there are multiple objects in the chart
        For Each oObj In .Axes
           oObj.AxisTitle.Text = oObj.AxisTitle.Text
        Next
'others go here
    End With
End Sub

Skip,

_[red][/red]