A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Graph and Input box for Date Range



 
 
Thread Tools Display Modes
  #1  
Old September 9th, 2009, 01:54 PM posted to microsoft.public.excel.charting
TAlgo
external usenet poster
 
Posts: 3
Default Graph and Input box for Date Range

All,

This is just my thought but have no idea how to proceed. Can someone
please provide a solution, I will really appreciate.

Not sure how to attach a spreadsheet by my data spreadsheet is
uploaded to File section known as DATA.XLSX.

Col A. contains dates ( 1-Jan to 16-Aug ) and Col B-K contains data
starting year 2001-2010 for the same dates.

I would like to create a Date Range Input box so whenever I specify
date ranges, it automatically pulls data of those dates from 2001 to
2010 and creates some type of line chart.

E.g I specify date1: 3-march and date2: 10-June then line graph
shopuld be create automatically.

Hope this is clear. Thanks in advance.
  #2  
Old September 9th, 2009, 02:00 PM posted to microsoft.public.excel.charting
TAlgo
external usenet poster
 
Posts: 3
Default Graph and Input box for Date Range

Not sure where to upload my sample file
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.