+ Reply to Thread
Results 1 to 5 of 5

Taking data from an ongoing weight chart and putting it into a line graph

  1. #1
    Registered User
    Join Date
    10-17-2018
    Location
    Plymouth
    MS-Off Ver
    2010
    Posts
    55

    Taking data from an ongoing weight chart and putting it into a line graph

    I know this sounds really easy. However I need two lines. One showing the ongoing weight record(which will get updated frequently and as such needs to automatically update to the graph) and one constant line for target weight that will stay static but allow me to see visually how I am doing.


    I have included an example of the record. If you can give a minor explanation of how to do this it would be great.


    My issue isn't creating the graph that bit is easy. It is adding the Target weight line that I cannot seem to do.


    Regards
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,695

    Re: Taking data from an ongoing weight chart and putting it into a line graph

    Hi,
    Make the target weight a second series by putting =$C$2 in D4 of your table.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-17-2018
    Location
    Plymouth
    MS-Off Ver
    2010
    Posts
    55

    Re: Taking data from an ongoing weight chart and putting it into a line graph

    Can you demonstrate in the document. I tried it but I must have done something wrong. Sorry I know this is simple compared to my other forum request. ill show what mess I have made of what you said in new attachment


    Quote Originally Posted by Richard Buttrey View Post
    Hi,
    Make the target weight a second series by putting =$C$2 in D4 of your table.
    Attached Files Attached Files
    Last edited by aabbey; 11-13-2018 at 06:27 AM.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,695

    Re: Taking data from an ongoing weight chart and putting it into a line graph

    Hi,

    See attached

    C2 was originally text since you'd added "Kg" to the 75. I've formatted C" to be
    0.0 "Kg"

    so that it holds the number 75 but displays as 75 Kg
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-17-2018
    Location
    Plymouth
    MS-Off Ver
    2010
    Posts
    55

    Re: Taking data from an ongoing weight chart and putting it into a line graph

    Great thanks. I see where I was going wrong now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1