Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Graphing inconsistent dates and data
I would like to graph some data - body weight for example. I would set up
the date on the X-axis and the weight on the Y-axis. When inputting the data, I would LIST every day sequentially and then record the weight next to the date. If I were to consistently record a weight reading every day, I would have a nice smooth graph. However, if I were to record a weight for 2 or 3 days and then skip a day or 2, I would have blanks (0's) by the skipped days. When I graph that data range, the graph goes haywire because it drops all of the way down to 0 on the skipped days. I could easily just delete the days when I didn't take a reading but that goofs up some of the other things I want to do. Is there a way to get Excel to generate a smooth graph? I was thinking there might be a way to "average" the weight on the skipped days, thereby forcing a smooth graph. Maybe this has already been figured out but I can't find it. Any suggestions / advice would be appreciated. TIA Chuck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ability to sum data by varying dates | Excel Worksheet Functions | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
How can I create a formula to locate data between two dates? | Excel Worksheet Functions | |||
Sum of Columns with Calendar Dates and Data | Excel Worksheet Functions | |||
How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) |