Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dan_Green
 
Posts: n/a
Default Graphs/Charts by country. Same Graph, different Source Data

Hi

I have sales information for 5 countries, each on separate sheets ( the
sheets are identical in format) . I have made graphs for the first country,
and I want to copy them to the other countries, and change the references to
pick up the right country information. Is there a quick way of doing this or
do i have to go into source information for each series for each graph and
change the sheet( country ) reference

I asppreciate any answers to this as atthe moment I've spent the better part
of a day changing sheet references

Rgds

Dan

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
bar graph question anantathaker Excel Discussion (Misc queries) 1 June 17th 05 03:44 PM
Graph Help- 12 month graph, but only want months that have passed coal_miner Charts and Charting in Excel 4 June 3rd 05 03:03 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
IF Statement difficulty susan hayes Excel Worksheet Functions 3 November 2nd 04 09:46 PM
If statements Mark Excel Worksheet Functions 3 November 2nd 04 08:39 PM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"