Timeline for Plotting daily values and weekly averages in the same chart
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 17, 2016 at 17:49 | vote | accept | Dirk101 | ||
| Nov 28, 2016 at 13:39 | answer | added | dav | timeline score: 0 | |
| Nov 25, 2016 at 19:18 | comment | added | Dirk101 | Looking through scatter chart types, I've found the "scatter with straight lines" type, which is exactly what I needed. If this is what you were referring to, feel free to add it as an answer and I'll tick it as the solution. | |
| Nov 25, 2016 at 15:27 | comment | added | Dirk101 | @dav the scatter chart really does do what I'm looking for, minus the trend line | |
| Nov 25, 2016 at 15:27 | comment | added | Dirk101 | Thank you both. @fixer1234 it's a very good alternative if I can't find exactly what I'm looking for. | |
| Nov 14, 2016 at 15:22 | comment | added | dav | Use an XY/Scatter chart and you can specify where every point is plotted. LIne charts force the horizontal axis to categorical values. | |
| Nov 12, 2016 at 17:27 | comment | added | fixer1234 | One way: expand your weekly data to repeat the value each day in the week (7 daily entries of each week's average). Use a scatter (XY) chart to plot the daily and weekly values as two series (it would look better using just lines, no point markers). The weekly values will display as a line that's horizontal for the week, running through the daily values. | |
| Nov 12, 2016 at 12:48 | history | asked | Dirk101 | CC BY-SA 3.0 |