If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I get the Fitness Chart for Men to work longer?
I have been using the Fitness Chart for Men Excel template to track my weight
loss. I find that the downloaded version only has 31 rows, at which point the borders end and it no longer graphs any data that I might enter. How do I extend this template so that it can track my weight for longer than one month? |
#2
|
|||
|
|||
How do I get the Fitness Chart for Men to work longer?
Prospect
That will be quite a project. You can simply copy down to extend it then clear data from columns B through E below row 31 but.......... Now you would have to adapt all the formulas in columns F through I to return a blank if nothing entered in A through E. =IF(B32="","",((B32*1.082)+94.42)-(D32*4.15)) entered in F32 =IF(B32="","",B32-F32) entered in G32 =IF(B32="","",(G32*100)/B32) entered in H32 =IF(B32="","",(B32/($I$2*12+$I$3)/($I$2*12+$I$3)*703)) entered in I32 All these would copied down a fair piece. The dates in Column A will increment with no problem if you select A29:A31 then copy down. Then you would have to set up dynamic ranges for each of the Charts' series For the dynamic ranges instructions for Charts' series, visit Tushar Mehta's site at http://www.tushar-mehta.com/excel/ne...rts/index.html Gord Dibben Excel MVP On Tue, 13 Dec 2005 09:46:02 -0800, "Prospect" wrote: I have been using the Fitness Chart for Men Excel template to track my weight loss. I find that the downloaded version only has 31 rows, at which point the borders end and it no longer graphs any data that I might enter. How do I extend this template so that it can track my weight for longer than one month? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to add animation to a chart - make lines appear | David Leonard | Powerpoint | 11 | June 2nd, 2005 12:33 AM |
Fan charts | Dean | Charts and Charting | 7 | May 30th, 2005 11:51 AM |
CPU Usage When working with a Template I Created | KM1 | General Discussion | 6 | May 24th, 2005 04:38 PM |
Rules no longer work | Salvador Aguilar | General Discussion | 0 | August 20th, 2004 06:20 PM |
Is it possible to plot 3 surfaces in a Pivot Chart? (Repost) | Alison | Charts and Charting | 5 | October 21st, 2003 11:00 PM |