Results 1 to 3 of 3

Thread: How can I update the charts' soure data programmatically?

  1. #1

    How can I update the charts' soure data programmatically?

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear all,

    How can I update the charts' source data programmatically using VBA which has same data format, but only from Sheet1 to Sheet 2?


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    You need to apply the SetSourceData method of the chart.

  3. #3
    Is there a way to do find and replace in the 'Select Data' dialogue box to make it quicker and easier to specify a different source sheet for a chart's data. For example, if I have 2 sheets with identical formats (created by copying sheet 1 to sheet 2), I would like to be able to quickly change the source of charts (on the different sheet, 3) to look at sheet 2 instead of sheet 1, without having to re-select the data or manually edit the path information in the dialogue box.

    Are there any such short cuts. I am not familiar with VBA but will learn if necessary because with over 100 charts looking at sheet 1 there has to be an easier way than to manually edit each chart to look at sheet 2 for its source data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts