Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link one chart to another?

Status
Not open for further replies.
globularbob

globularbob

Programmer
Nov 15, 2002
69
US
Hello

My boss uses an excel spreadsheet that has a detail tab, a detail w/ graphs tab, and a graph only tab. Why? This is what his boss wants to see and he will not budge because it's what he's used to. My dilemma is that I have to spend tons of time updating the exact same charts. Is there a way to link one chart to another so that when I update the range of the first, the second one also updates?

Thanks in advance for your help!

GB
 
Sort by date Sort by votes
That's what I thought. Since my data range changes for one chart, I have to change them for each similar chart.

Thanks!
 
Upvote 0 Downvote
No. The data is the same for each chart, but the data range moves from month to month. So, if you update the range on 1 chart,the other still looks like last month's.

Does this make sense?

Thanks for entertaining my question!

Gb
 
Upvote 0 Downvote
Skip,

It sounds like he wants to centralize the data and have charts in 2 separate locations to automatically update. I think he can use the "OFFSET" function for both charts.
You're the expert on offset.

Jim
 
Upvote 0 Downvote
Jim,

I was suspecting that too, but I wanted a confirmation and some additional information.

GB,

Your task ought to be able to be accomplished with ONE data source, but using the OFFSET function to 1) select the appropriate starting point for each chart and 2) define the related range for the associated series. So I need a better description of the source data and the subsets of data needed for each chart. Like, post your COMPLETE source data. :)

Skip,
Skip@TheOfficeExperts.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Wicca
  • Locked
  • Question
MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another
Replies
16
Views
699
Wicca
Wicca
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
1K
combo
combo
PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
469
Andrzejek
Andrzejek
rk68
  • Locked
  • Question
matching data from one excel sheet to another
Replies
6
Views
362
rk68
rk68
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
382
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top