To see where the data is mapped from just click on the graphed line. The data ranges will be
highlighted for you.
All that I did to create the graph is to create the 2 columns: Date & weight. The software assumes
that the first variable is the x axis (left to right). It has been formated to use the date format
in the form of mm/dd/yy. This will automatically put the dates at the bottom of the graph. The data
is set up as weekly to represent my unofficial WW weighins. The next column (weight) is the y-axis
(up and down).
Now go have a chocolate for me. I've run out of points for today.
"Fred" <
[email protected]> wrote in message
news:[email protected]...
> I like it. Now to see if I can learn from it (G)
>
> Like how you got labels that are monthly? Where the data was mapped from, etc, etc.. It may
> involves years of exploration in which I will have no time to consume Miss Meringues or dried
> fruit or chocolates! (G)
>
> On Mon, 19 Jan 2004 13:20:00 GMT, "Laura" <
[email protected]> wrote:
>
> >Nothing fancy but try this:
http://home.att.net/~extra623/weightchart.xls.
> >
> >Just change your dates & weights to match yours. You will have to go into the chart (right click
> >weight axis) and adjust the max/min weights to
match
> >yours. Mine are 250 & 140 starting at the end of April 2003.
> >
> >"Laura" <
[email protected]> wrote in message
news:_vQOb.33196$VS4.1032029@bgtnsc04-
> >news.ops.worldnet.att.net...
> >> I'll post something tonight. I've only got about 1/2 hr before I leave
for
> >> work.
> >>
> >> "Fred" <
[email protected]> wrote in message
> >>
news:[email protected]...
> >> > Laura might be able to provide a better way to chart something if based on data from her
> >> > spreadsheet model. Especially, since not
being
> >> > an Excel person, mine seems truly almost worthless. That may be because I've charted the
> >> > year+ and it shows NO detail whatsoever - just a very slightly sloping line and I mean
> >> > slightly.
> >> >
> >> > Laura???
> >> >
> >> > On Sun, 18 Jan 2004 23:02:04 -0500, "bird" <
[email protected]> wrote:
> >> >
> >> > >Once you put all the work into your spreadsheet any chance of you
> >sharing
> >> > >it? I have Laura's spreadsheet that is great but I think it would
be
> >> > >helpful to have a chart for progress. Bird "Fred" <
[email protected]> wrote in
> >> > >message
news:[email protected]...
> >> > >> I was think of graphing my progress and figured that excel might
do
> >> > >> some automatic labeling or some such so that I could create a
spread
> >> > >> (maybe this one should be called a narrow) sheet. I am also
curious
> >> > >> about where I was during certain periods over the last year in reference to my skiing,
> >> > >> biking, etc.
> >> > >>
> >> > >> Something like:
> >> > >>
> >> > >> Oct 30 Nov 6 Nov 13 Nov 20 ................................ in
the
> >> > >> row
> >> > >>
> >> > >> I thought Excel might know how to automate this so that I do not
have
> >> > >> to enter each of those days - just incrementing weeks across the
top
> >> > >> row. Thanks in advance.
> >> > >
> >> >
> >