![]() ![]() Find the “Insert” tab, look under the section for “Charts” then click to choose a column graph.Click to highlight then drag the mouse to highlight all of the relevant data, including your weight values and the corresponding dates. Place the cursor over the box with “Date” typed in it. ![]() For instance, if on January 12 you weighed 180 lbs., input this number in the same row, but in the column next to the date. Input your weight for each of the corresponding dates in Column B.Use the format “12-Jan” and Excel will read this as January 12 of the current year. Whether you monitor each day, every Saturday or on the first of each month, input the date continuing down until the end of the column. Record the date every time you weigh yourself in Column A.Input the word “Date” in Column A, Row 1.Do this by going to “Programs,” then “Microsoft Office,” then “Microsoft Office Excel.” Start by saving the spreadsheet to your hard drive right away using a memorable file name, and in a folder that’s easy to locate on your computer. Here’s how you make a weight chart using Excel: This certainly inspires you to achieve your goal weight then maintain that once you have accomplished it. Create a colorful weight loss graph to go with your weight loss competition spreadsheet. Making a graph isn’t that hard using the Excel program on your computer. This allows you to pinpoint any plateaus or patterns in your weight loss as time goes by. Another way to motivate you is by creating a weight loss challenge spreadsheet or graph that gives you a visual image of your progress. Perhaps the greatest consolation you can have when you go through your weight loss spreadsheet is to know how close you are to achieving your weight loss goal. Weight loss spreadsheet 30 (20.50 KB) How do I create a weight chart in Excel? Change the “Decimal Places” to “1” then click “OK.” Right-click then click “Format Cells” Go to the “Number” tab then choose “Percentage” in the “Category” box. Select all of the cells with formulas in them.Just change the “B” in the formula to the corresponding letter of the column. You may copy then paste the formula from cell B3. Input this formula in each of the cells in row 3.Multiplying by negative 1 in the end creates a positive number. ![]() This formula tells gives you the difference between cells B2 and A2 as a percentage amount.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |