Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic chart on user selected data range in Excel 2007 | Charts and Charting in Excel | |||
automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
Referring to a user-selected range | Excel Programming | |||
Identify Range Selected By User | Excel Programming | |||
Determining end of user-selected range | Excel Programming |