auto update of a chart

G

Guest

Hi,
With a line chart ,I used to update data table by adding a row data every
day.After that I update source data--data range of my chart by manually
increasing a row number.Example:blush:n 20/jun/06 my data range =sheet1!
$a$1:$b$25.on 21/jun/06 my data range changes to =sheet1!$a$1:$b$26.
Is it possible to put a formula in data range to automaticalyy select source
data from data table.
 

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

Dynamic Chart Update Issue 7
Source Data 2
A sorted chart? 1
Select Specific Data From Cells For A Chart 4
Only Include Last Four Entries in a Chart 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Expand Chart Source with New Row(s) 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top