Archive of Mr Excel Message Board

Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home

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

Re: charts
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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.