plotting chart with user selected range from current workbook
 

:confused:
Right now, I've a worksheet that continuously log data daily int
sheet1 of my workbook. I've created a xy scatter chart as a new char
worksheet, namely chart1.

What I want to do is to create a refEdit box that allows user to selec
a range of date from column A. Upon clicking a "ok" button, my scrip
will update chart1 accordingly. In my chart, my x-axis is from column
(date) and my y-axis is from column B (flowrate of the correspondin
day).

Thanks in advance :

--
Message posted from http://www.ExcelForum.com