Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart bases on user input dates
Im wondering if this is even possible. I know my way around Excel a fair bit
but am completely oblivious when it comes to charts. I have a tab where we record the type of work we do and the date it was raised & completed. What I want is for a chart to appear on another tab based on specifc dates a user can apply. Foe example: Tab 1 will look similar to this: Type Date Raised Raised By Closed klljjbjbkl;b 01/01/2007 jlnhjnjklnl 03/01/2007 fjfnsdfnmsdf 10/01/2007 jn.jlnn.jn 21/01/2007 kgkbjkbjkbjk 23/01/2007 kjlnjlnlnlnl fbgbstbstgbsgb 01/02/2007 ddvsdfbsdbss Then on the second tab, this will be at the top: Please enter date from [cellB1] to [CellD1] and below this will show the graph based on the completed date field in chart one dpending on what was entered at the top of tab 2. Is this possible? Thanks in advance for your help! Maver1ck666 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart bases on user input dates
Could you use this approach:
http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Maver1ck666" wrote in message ... Im wondering if this is even possible. I know my way around Excel a fair bit but am completely oblivious when it comes to charts. I have a tab where we record the type of work we do and the date it was raised & completed. What I want is for a chart to appear on another tab based on specifc dates a user can apply. Foe example: Tab 1 will look similar to this: Type Date Raised Raised By Closed klljjbjbkl;b 01/01/2007 jlnhjnjklnl 03/01/2007 fjfnsdfnmsdf 10/01/2007 jn.jlnn.jn 21/01/2007 kgkbjkbjkbjk 23/01/2007 kjlnjlnlnlnl fbgbstbstgbsgb 01/02/2007 ddvsdfbsdbss Then on the second tab, this will be at the top: Please enter date from [cellB1] to [CellD1] and below this will show the graph based on the completed date field in chart one dpending on what was entered at the top of tab 2. Is this possible? Thanks in advance for your help! Maver1ck666 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
User Input Required | Excel Worksheet Functions | |||
User Data Input | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Ask user for input during marco | Excel Discussion (Misc queries) |