Clear Chart1

    I have an active working Chart1 but I want to clear it every time I click the button to execute the Chart.


    How do I do that?

    Code
    Sheets("Graph").ChartObjects("Chart 1").Chart.???

    Re: Clear Chart1


    Code
    Sheets("Graph").ChartObjects("Chart 1").Chart.ChartArea.Clear


    should do it.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login