Create a line graph in Excel - part 2
This step-by-step tutorial shows how to use Excel to add meaningful color, sizing, markers, and text to a simple line graph, making the message of the visual clear and powerful. Go beyond a default Excel graph to create something custom, so you can drive deeper understanding with your audience.
TIMELINE
00:00 Intro
01:15 Format the axes
06:05 Adjust the colors
07:20 Add data markers
08:10 Experiment with line size
09:45 Use a custom graph title
12:10 Modify line details (color, style, fill, width)
20:20 Outro
BONUS RESOURCES
● Watch this tutorial for Tableau (available to premium only): https://community.storytellingwithdata.com/videos/lets-create-a-line-graph-in-tableau-finding-the-ri?videoSeries=a631edc4-4a03-4c74-aa24-83bbf358865d
● Two ways to add data labels: https://www.storytellingwithdata.com/blog/2021/2/9/how-to-do-it-in-excel-adding-data-labels
IMPROVE YOUR DATA VISUALIZATION & STORYTELLING SKILLS
📚 Read the books: https://www.storytellingwithdata.com/books
🖥 Follow the blog: https://www.storytellingwithdata.com/blog
📊 Practice in the SWD community: https://community.storytellingwithdata.com/
🎧 Listen to the podcast: https://www.storytellingwithdata.com/podcast
🍎 Attend a workshop: https://www.storytellingwithdata.com/public-workshops
STAY CONNECTED
👉 LinkedIn: https://www.linkedin.com/company/storytelling-with-data-llc
👉 Twitter: https://twitter.com/storywithdata
💡 Don’t forget to subscribe for new videos! https://www.youtube.com/c/storytellingwithdata?sub_confirmation=1
#ExcelTutorial #datavisualization #datastorytelling
Видео Create a line graph in Excel - part 2 канала storytelling with data
TIMELINE
00:00 Intro
01:15 Format the axes
06:05 Adjust the colors
07:20 Add data markers
08:10 Experiment with line size
09:45 Use a custom graph title
12:10 Modify line details (color, style, fill, width)
20:20 Outro
BONUS RESOURCES
● Watch this tutorial for Tableau (available to premium only): https://community.storytellingwithdata.com/videos/lets-create-a-line-graph-in-tableau-finding-the-ri?videoSeries=a631edc4-4a03-4c74-aa24-83bbf358865d
● Two ways to add data labels: https://www.storytellingwithdata.com/blog/2021/2/9/how-to-do-it-in-excel-adding-data-labels
IMPROVE YOUR DATA VISUALIZATION & STORYTELLING SKILLS
📚 Read the books: https://www.storytellingwithdata.com/books
🖥 Follow the blog: https://www.storytellingwithdata.com/blog
📊 Practice in the SWD community: https://community.storytellingwithdata.com/
🎧 Listen to the podcast: https://www.storytellingwithdata.com/podcast
🍎 Attend a workshop: https://www.storytellingwithdata.com/public-workshops
STAY CONNECTED
👉 LinkedIn: https://www.linkedin.com/company/storytelling-with-data-llc
👉 Twitter: https://twitter.com/storywithdata
💡 Don’t forget to subscribe for new videos! https://www.youtube.com/c/storytellingwithdata?sub_confirmation=1
#ExcelTutorial #datavisualization #datastorytelling
Видео Create a line graph in Excel - part 2 канала storytelling with data
Показать
Комментарии отсутствуют
Информация о видео
16 декабря 2021 г. 18:14:32
00:21:22
Другие видео канала
![The importance of contrast](https://i.ytimg.com/vi/Lyiu6KBekCg/default.jpg)
![Ten considerations when designing a graph](https://i.ytimg.com/vi/6uNg-E5Lhyo/default.jpg)
![What you'll learn in an SWD masterclass](https://i.ytimg.com/vi/TOsSPwd5C5c/default.jpg)
![Become a dataviz SUPERSTAR: PART 5](https://i.ytimg.com/vi/Z74gCQzgJLo/default.jpg)
![Can you measure the ROI of data visualization?](https://i.ytimg.com/vi/5cdno_3HhB0/default.jpg)
![Become a dataviz SUPERSTAR: PART 4](https://i.ytimg.com/vi/aDs4C8pgnO8/default.jpg)
![Create a line graph in Excel - part 1](https://i.ytimg.com/vi/FnvE1SF1Wx0/default.jpg)
![Peek inside Cole’s new book: Daphne Draws Data](https://i.ytimg.com/vi/IHsEIkDn_74/default.jpg)
![Questions about questions](https://i.ytimg.com/vi/ovKWsy68pVM/default.jpg)
![How to focus attention in data visualization](https://i.ytimg.com/vi/kfGbI9wovZk/default.jpg)
![Create beautiful custom color palettes in PowerPoint](https://i.ytimg.com/vi/mn81T0Mw6Zc/default.jpg)
![Welcome to the SWD channel!](https://i.ytimg.com/vi/XUiw6QDOGvo/default.jpg)
![Make the most of your new role in data](https://i.ytimg.com/vi/ek-7aLtYTa8/default.jpg)
![Become a dataviz SUPERSTAR: PART 3](https://i.ytimg.com/vi/6D3gZDLqd9w/default.jpg)
![The little of vis design with Andy Kirk](https://i.ytimg.com/vi/Au9F2VekWx4/default.jpg)
![Overcoming resistance to new graphs](https://i.ytimg.com/vi/-r8rfgNg_Lo/default.jpg)
![Five easy tips for better data communications](https://i.ytimg.com/vi/uCpYUrJVZUA/default.jpg)
![Data storyteller improves STACKED BARS | EP.1 Where are your eyes drawn?](https://i.ytimg.com/vi/0AoS22GoosI/default.jpg)
![The art of exploring and explaining data](https://i.ytimg.com/vi/IfKlOC5HSHI/default.jpg)
![How to add emphasis to your area graphs #excel](https://i.ytimg.com/vi/1aoXN7Qra1U/default.jpg)