update data source for all charts in a workbook

F

frontdeskcps

New Member
Joined
Dec 7, 2018
Messages
4
I have created 2 "master" workbooks which we are copying and renaming. I can get the source date for the workbooks to change using edit links but it doesn't change the source data for the charts. Is there a way to change all the chart's source data when you change the workbook's source data? Or a way to change the source data for all the charts within the workbook (multiple sheets) at one time? The simpler the better - trying to make it easy for a beginning excel user to accomplish.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You must log in or register to reply here.

Similar threads

C
  • Question Question
Create a link to another workbook via form control
Replies
1
Views
43
Micron
M
C
  • Question Question
Updating both sheets in two workbooks from either sheet source
Replies
6
Views
217
chazrab
C
C
  • Question Question
Linking two sheets in different workbooks takes a long time even with only 500 rows of data. Is there a quicker, more efficient way to do this?
Replies
0
Views
160
chazrab
C
M
  • Question Question
Is it possible to dynamically add chart series' based on dynamic named range?
Replies
1
Views
656
StephenCrump
S
Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
221
cooleomter
C

Forum statistics

Threads
1,223,704
Messages
6,173,984
Members
452,540
Latest member
haasro02

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top