dahowarduk
New member
In column A (say) cells A1 to A70 show my target weight over the next 70 days
After 10 days (of slimming!) , my actual weight can be found in cells B1 to B10. The cell values in column B are a calculation based on the input of 3 figures i.e. my weight in stones, pounds and ounces, all converted to stones. (NB 16 ounces = 1 pound ~ 14 pounds = 1 stone)
So I have a chart showing A1 to A70 and B1 to B10, which works fine.
However, tomorrow I will want my chart to show A! to A70 against and B1 to B11, and so on.
I can change the chart by manually editing the Data Source information..but this is a pain!
How can this be achieved automatically?
After 10 days (of slimming!) , my actual weight can be found in cells B1 to B10. The cell values in column B are a calculation based on the input of 3 figures i.e. my weight in stones, pounds and ounces, all converted to stones. (NB 16 ounces = 1 pound ~ 14 pounds = 1 stone)
So I have a chart showing A1 to A70 and B1 to B10, which works fine.
However, tomorrow I will want my chart to show A! to A70 against and B1 to B11, and so on.
I can change the chart by manually editing the Data Source information..but this is a pain!
How can this be achieved automatically?