LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default copy graph from a Worksheet based on a field in another Worksheet

Here goes! Hope this makes since and I'll try to be as basic as possible.
Excel 2003
I have a Workbook with the following worksheets:
Form-Print
Work-Sheet
January
February
March
(Etc. a sheet for each month)

1-The 'Work-Sheet' tab has user data that is input monthly for the prior
month and several calculated columns based on that input.
2-All the 'Month' tabs (12 in all) have formulas to extract the data for
only that month from the 'Work-Sheet' tab, put it into columns based on the
month and year, and has a graph of this data for all the years. All this is
done automatically in that 'Months' tab with no user input within that tab.
3-The 'Form-Print' tab is strictly an easy to read document based on a given
"month-year" field that is input by the user. This is given to top
management at the end of each month showing that particular months info as
well as its history from prior years including the graph for that month.

I have gotten all the info in the text portion of the 'Form-Print' tab
for the month with no problems. All this info comes from only the
'Work-Sheet' tab. My problem is the fact that I need to also get the graph
from the correct 'Month' tab for the data as well as automatically size it ti
a specific size. I have found nothing to allow me to get the graph from the
matching 'Month' tab based on the "month-year" input by the user on the
'Fornm-Print' tab.

I prefer to get this done strictly with formulas and/or copy functions.
I have no experience with VB what-so-ever and would have to be baby-stepped
through it for VB to work.

If you have an easy way for me to get this done I'd be forever greatful!
 
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
How do I copy a graph and use the data in the new worksheet? Brendanluc Charts and Charting in Excel 9 February 9th 08 06:49 AM
filtering out records from one worksheet by comparing a field in it with a field in another worksheet [email protected] New Users to Excel 0 May 9th 07 01:06 AM
Copy Row to worksheet based on criteria JoePineapples Excel Discussion (Misc queries) 1 March 7th 07 09:05 AM
copy data from 1 worksheet to another based on a condition [email protected] Excel Worksheet Functions 9 September 4th 06 02:45 PM
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Excel Discussion (Misc queries) 2 August 24th 06 05:26 PM


All times are GMT +1. The time now is 12:49 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"