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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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
74
Micron
M
C
  • Question Question
Updating both sheets in two workbooks from either sheet source
Replies
6
Views
233
chazrab
C
SandsB
  • Question Question
Chart Type changes when updated
Replies
0
Views
70
SandsB
SandsB
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
176
chazrab
C
M
  • Question Question
Is it possible to dynamically add chart series' based on dynamic named range?
Replies
1
Views
758
StephenCrump
S

Forum statistics

Threads
1,224,738
Messages
6,180,673
Members
452,993
Latest member
FDARYABEE

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