Skip to main content
Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

5
  • 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.
    – fixer1234
    Commented Nov 12, 2016 at 17:27
  • Use an XY/Scatter chart and you can specify where every point is plotted. LIne charts force the horizontal axis to categorical values.
    – dav
    Commented Nov 14, 2016 at 15:22
  • Thank you both. @fixer1234 it's a very good alternative if I can't find exactly what I'm looking for.
    – Dirk101
    Commented Nov 25, 2016 at 15:27
  • @dav the scatter chart really does do what I'm looking for, minus the trend line
    – Dirk101
    Commented Nov 25, 2016 at 15:27
  • 1
    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.
    – Dirk101
    Commented Nov 25, 2016 at 19:18