Update same charts in multiple sheets at once

D

Div

Hi!
I am relatively Novice in excel. I am currently working on a project where I
have same charts in multiple sheets. Each sheet is for different audience,
therefore, I can not keep them together. I want to know if there is a way to
maintain all these charts at once. my question is -
1. Update chart 1 in sheet 1 should update chart 1 in sheet 2

is it possible?
Thanks in advance
Div
 
B

Bernard Liengme

If the data being charted is the same:
The data is on Sheet1
On Sheet2 you have formulas like =Sheet1!A1
So now both sheets (or many sheets) have the same data
Make charts as needed
When you EDIT the data in Sheet1 all the charts will update

But maybe you mean you will be ADDING new data at the bottom of the table
and want the charts to be dynamic?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create multiple bar charts at the same time? 0
Charts not updating 1
All sheets in workbook have same rows to repeat at top 1
One Chart, Same Data ranges, different source sheets 4
Duplicate chart names on multiple sheets 2
Data Labels in Excel Pie Charts 1
PowerPoint how to update chats in PowerPoint 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16

Top