View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
annette2002 annette2002 is offline
external usenet poster
 
Posts: 1
Default plotting chart with user selected range from current workbook


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