This is an Eval Central archive copy, find the original at depictdatastudio.com.
Dotted lines have a specific purpose in dataviz: for projections or estimations. Not just because.
Stick around for the how-to lesson in Microsoft Excel.
You’ll learn how to select a single dot (or “marker”) along the line, which controls the preceding line segment.
Then, you can turn just one section of the graph into a dotted line.
https://www.youtube.com/watch?v=titF7TQcwDc
What’s Inside
0:00 Don’t Use Dotted Lines “Just Because”
0:20 Dotted Lines are for Projections or Estimations
1:24 How to Make Dotted Lines on Excel Graphs
3:44 Questions??