Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) | | |
#3
|
|||
|
|||
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) | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create daily logbook | Excel Discussion (Misc queries) | |||
What Bus. templete do I use for daily cost w/ daily & cum cost ? | Excel Discussion (Misc queries) | |||
I need a daily sales sheet to pull from monthly figures sheet | Excel Worksheet Functions | |||
How do I protect cell formulas used for daily counts? | Excel Worksheet Functions | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel |