Replace values in chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amag - 16 Apr 2008 10:36 GMT

I have some 20 charts in one file linked to a sheet (Sheet A). Now I
have to replicated these charts except that they now should be linked
to another sheet (Sheet B).
I dont want to individually go to each chart, right click and change
the data source. Is there a simple way to do it, something like Ctrl
H, wherein you replace all?

Thanks in advance.

Best Regards

Reply to this Message

Jon Peltier - 16 Apr 2008 22:38 GMT

Make a copy of the first workbook, copy the data from sheet B onto sheet A,
and the charts will now display the new data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

>I have some 20 charts in one file linked to a sheet (Sheet A). Now I
> have to replicated these charts except that they now should be linked
[quoted text clipped - 6 lines]
>
> Best Regards

Reply to this Message