Copy a chart from one workbook to another with a link

Solved
mamy30 -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello

Here is my problem: I want to copy/duplicate a chart into another workbook (which synthesizes several workbooks) and I want them to be linked together. If I duplicate my sheet containing the chart, my "new" chart is indeed linked to the original table (if I change the values in the original table, both charts update), but if I add a curve to the original chart or change the color, the change does not occur in the "new" chart.

I searched online for a solution but came up empty.

Does anyone have the solution?

Thank you.

6 answers

  1. eugene
     
    Hello,
    I’m afraid that may not be possible; I just tried it on my old Excel 2000, with no results. Perhaps on more recent versions...
    Take care,
    Best regards.
    1
    1. mamy30
       
      :(
      Thank you anyway...
      0