creating charts from one constantly changing data point!

HI,

Im using xl to make my life easier, only its not!

so, i have data that comes into cell a1 from an external data source. i dont really want to have rows and rows of data as i only need to see the last value. however, what i would like to do is make a chart the logs this value throughout the day.

any ideas would be very much appreciated!!

Hi,

If you only ever want to chart cell A1, then just create a chart with cell A1 as the data source.

If your data update actually inserts new rows, then the reference to A1 will move down, This is what you don't want. In that case, use a range name with the defiinition, for example with the range called chrtData

=INDEX(Sheet1!$A:$A,1)

Then use that range name in the series formula for the chart:

=SERIES(,,Book1!chrtData,1)

thanks for your time. I think i may just go for the rows of data option.
IF cell a1 is updating, how do i make the previous updates moved down the page?

sorry, know this is off topic.

thanks.

Hi, this is not off topic, but it's not clear what you want to achieve.

So, please start over. What's happening right now? What would you like to happen instead?