Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2007

Tip: Looking for answers? Try searching our database.

Chart bases on user input dates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Maver1ck666 - 07 Sep 2007 11:10 GMT
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
Jon Peltier - 07 Sep 2007 14:30 GMT
Could you use this approach:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> Im wondering if this is even possible. I know my way around Excel a fair
> bit
[quoted text clipped - 29 lines]
>
> Maver1ck666
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.