plotting chart with user selected range from current workbook

A

annette2002

: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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create chart with column axis 10
Chart with a defined named range? 11
Plotting Date and Time on the same chart axis 1
use ComboBox value to select range and then use selected range tocreate a chart 3
3d column chart dynamic range 0
Copy user selected range from all open workbooks 2
'Automatic' change to Line Chart from XY Scatter Chart - cannotchange back 2
help with chart script and data labels 7

Top