MrExcel Publishing
Your One Stop for Excel Tips & Solutions

charts


Posted by Stephen Rogers on October 27, 2001 3:00 PM

I am currently working on average age, time etc for GPS (satelite position). I have the calculation done on one page and from these calculations, each station has its own graph. On these graphs I have been entering the average age, time etc onto the graphs using text boxes ie:

average age 7
average time 21
total downtime 2:11
duration 24hr

Is there any way the figures from my calculations can be transferred automatically using text boxes onto the graphs page. Also on the graphs chart title is there a way the date can be updated each day without havinng to input it manually


Posted by bob umlas on October 27, 2001 7:32 PM

average age 7 average time 21 total downtime 2:11 duration 24hr

------------
no -- the data needs to exist in cells of the worksheet, not inside text boxes.