none
VBA - How to copy chart to another a worksheet RRS feed

Answers

  • You don't provide much information, so here is a generic macro. It copies the first chart from Sheet1 to Sheet2:

    Sub CopyChart()
        Dim cht As ChartObject
        Set cht = Worksheets("Sheet1").ChartObjects(1)
        cht.Copy
        Worksheets("Sheet2").Paste
    End Sub


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by sara1984 Wednesday, October 31, 2018 1:47 PM
    Tuesday, October 30, 2018 3:41 PM
  • Hi sara,

    Thanks for Hans's reply. You can try it.

    And the following links are some similar questions:

    Copy chart from one sheet to another

    Copying Charts From One Sheet to Another

    Hopefully it helps you.

    Best Regards,

    Lina


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    • Marked as answer by sara1984 Wednesday, October 31, 2018 1:47 PM
    Wednesday, October 31, 2018 2:53 AM

All replies

  • You don't provide much information, so here is a generic macro. It copies the first chart from Sheet1 to Sheet2:

    Sub CopyChart()
        Dim cht As ChartObject
        Set cht = Worksheets("Sheet1").ChartObjects(1)
        cht.Copy
        Worksheets("Sheet2").Paste
    End Sub


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by sara1984 Wednesday, October 31, 2018 1:47 PM
    Tuesday, October 30, 2018 3:41 PM
  • Hi sara,

    Thanks for Hans's reply. You can try it.

    And the following links are some similar questions:

    Copy chart from one sheet to another

    Copying Charts From One Sheet to Another

    Hopefully it helps you.

    Best Regards,

    Lina


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    • Marked as answer by sara1984 Wednesday, October 31, 2018 1:47 PM
    Wednesday, October 31, 2018 2:53 AM
  • Hi guys,

    Thanks very much. You all helped me a lot.

    Thanks again.

    Wednesday, October 31, 2018 1:50 PM