Leave a Reply

Your email address will not be published. Required fields are marked *

Dotted Lines are for Projections (& How-To Instructions for Excel)

Ann K. Emery
Updated on: Jun 11th, 2024
Data Visualization, Data Visualization in Excel
, , ,

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??

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Leave a Reply

Your email address will not be published. Required fields are marked *

You Might Like

Soar Beyond the Dusty Shelf Report

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

Enroll

20 Stress-Free Charts for Dashboards (That You Can Make in Spreadsheet Programs like Excel)

You’ll learn about 20 stress-free charts that we can make inside spreadsheet software like Microsoft Excel. These visuals can be added to static or interactive dashboards. They’re fast for us to make… which means a quick turnaround time for your audiences. No need to wait weeks or months until a dashboard is ready! These visuals are made within minutes, so your dashboard is ready same-day.

More »

Great Graphs

Inside our flagship dataviz course, you’ll learn software-agnostic skills that can (and should!) be applied to every software program. You’ll customize graphs for your audience, go beyond bar charts, and use accessible colors and text.

Enroll

Subscribe

Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.