I need to create a line chart that will change the date range based on what what a user inputs.
If the date range in 6/01/11 to 9/01/11, the excel file returns '140' for start month and '143 for end month. I would like a chart to be displayed that shows A142:A145 for the dates and I142:I145 for values.
Your help is appreciated.
Bookmarks