Plotting daily changes
 

Hi,

I wish to be able to plot changes in a specific figure on a daily basis.

I have the figure in cell B5. This is updated daily, but once changed the
history is lost. Is it possible, still using the existing layout, to add a
chart (date against figure) which will record the changes?

All help appreciated.
--
Wercs.

(Excel 2002 SP3)

To the best of my (limited) knowledge ... if you want to make a chart, then
you need a data series to work from - Excel hasn't got any way of knowing
what the daily values have been in the past unless they're stored in some
way.
One way of doing it would be to create a table of dates & values and update
that table each day. Then in your existing sheet, instead of entering
today's value, you can use a formula to reference to your date/value table
and return the value for whatever day that you're interested in.
You can then make your chart from the date/value table, for whatever date
range you choose.
Rgds,
ScottO

"Wercs" wrote in message
. uk...
| Hi,
|
| I wish to be able to plot changes in a specific figure on a daily basis.
|
| I have the figure in cell B5. This is updated daily, but once changed the
| history is lost. Is it possible, still using the existing layout, to add
a
| chart (date against figure) which will record the changes?
|
| All help appreciated.
| --
| Wercs.
|
| (Excel 2002 SP3)
|
|

Yes, I'd considered a separate chart, but wondered if there was more
sophisticated way.

Rgs.


"ScottO" wrote in message
...
To the best of my (limited) knowledge ... if you want to make a chart,
then
you need a data series to work from - Excel hasn't got any way of knowing
what the daily values have been in the past unless they're stored in some
way.
One way of doing it would be to create a table of dates & values and
update
that table each day. Then in your existing sheet, instead of entering
today's value, you can use a formula to reference to your date/value table
and return the value for whatever day that you're interested in.
You can then make your chart from the date/value table, for whatever date
range you choose.
Rgds,
ScottO

"Wercs" wrote in message
. uk...
| Hi,
|
| I wish to be able to plot changes in a specific figure on a daily basis.
|
| I have the figure in cell B5. This is updated daily, but once changed
the
| history is lost. Is it possible, still using the existing layout, to
add
a
| chart (date against figure) which will record the changes?
|
| All help appreciated.
| --
| Wercs.
|
| (Excel 2002 SP3)
|
|