![]() ![]() * If you wish, you may move Data Retrieved 1 table to other sheet so that only the Data Entered table and the chart are visible in the current sheet. * If you wish, you may hide column C (and column D) in Data Entered table. Table definitions are as follows (only showing the first several rows). Where the sheet before filterings is as follows: The sample sheet after applying necessary filterings: Note that we need to use scatter chart in order to handle possible skipped dates correctly. This chart will only use the visible data and thus be automatically updated reflecting the change in source. Scatter Chart 1 is sourced from Data Retrieved 1 table. In Data Retrieved 1 table, set A2 to the earliest date in Data Entered table and retrieve values for each date from the date in A2 to the last date in Data Entered table and filter the rows by value so that only the rows with value >0 will be shown. This way the table can be of fixed visible size and the top row will be always the row for today. ![]() ![]() In Data Entered table, set A2 to a future date, that would be one year ahead although here it is for brevity's sake, and create rows for every date from beginning to the date in A2 and filter the rows by condition(s) on date to show only the recent 14 days. In this scheme I'd create master data table (Data Entered) for storing data and a retrieved data table (Data Retrieved 1) for creating chart as shown below. I'd separate data model and view and keep data model as simple as possible. If you’re looking for a fun FREE 2024 WEIGHT LOSS TRACKER Template PDF to download, you’ve come to the right place This is a FREE Super-Cute Instant Downloadable Weight-Loss Tracker in both letter-size (8.5 x 11) or bullet journal A5 size (5.83 x 8.27). This may not be exactly what you're looking for but here's a setup I'd use for such data entry and viewing. Also, the weight has to move one row at a time to be in the right row at the right date. Now the other way round, it might be difficult, because the table expands down, but the most current date should be on top. So I hide every cell which didn't have content at all. And filter, which only showed the cells where the formula had added something. And I could enter my weight.īasically, I had a formula which added the date to another cell, if the date was today. I had it working "upside down", so that the most current date was on the very buttom, and the table expanded each day. In the end, I want to enter a weight each day, and display the table in a chart. I want to have a fixed row, so it stays in position, the design and everything stays as well, but the content can move.Īlso, I want my table to expand each day, one row at a time, moving the date as shown. I have a problem designing my weight tracking table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |