Тёмный

You can make Economist style graphs in Excel! Make your graphs look better with these tips 

Luke Fox
Подписаться 675
Просмотров 18 тыс.
50% 1

In this video we re-create a graph from the Economist magazine. One of the reasons this publication is so successful is they communicate really well. The best thing - you can as well with a few simple tricks! Learn how they do it by changing colours and inserting labels which will make a huge difference and have your colleagues stunned.
Sources:
Economist: www.economist.com/graphic-det...
Our world in data:
ourworldindata.org/coronavirus

Опубликовано:

 

6 янв 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 15   
@steves6557
@steves6557 Год назад
Wow, so many useful tips. My fav part is adding the data labels on the chart, color coding them to the line, then delete the legend. 👍
@thisislukefox
@thisislukefox Год назад
Glad you liked it!
@sniya
@sniya Год назад
The algorithm has blessed me with your video. Thank you. This is really useful.
@thisislukefox
@thisislukefox Год назад
Glad it was helpful!
@merlintolstyk8055
@merlintolstyk8055 Год назад
Thank you. I've been trying to figure out how to format the axit to just show the year on a chart for the longest time. You have just made my life so much better.
@thisislukefox
@thisislukefox Год назад
Glad it helped!
@allsports13
@allsports13 Год назад
I just made an excellent line graph for a work presentation following your steps. Thanks for this.
@thisislukefox
@thisislukefox Год назад
Glad it helped!
@larsmees4952
@larsmees4952 8 месяцев назад
It would be interesting to see you make an Office theme with the color theme and fonts of the Economist. It allows you to save soooo much time and ensures consistency between different graphs that have the same style. If people only know how to change the graph manually and edit every one of the graph’s properties one by one, they won’t do it; they will just use the built-in themes because they save them so much time TL;DR I would love to see a video of you making an Economist Office theme 😄
@thisislukefox
@thisislukefox 5 месяцев назад
I will add it to the list! Great suggestion!
@weiyang145
@weiyang145 10 месяцев назад
How to make y axis above the gridline?
@ismaelkourouma5558
@ismaelkourouma5558 10 месяцев назад
How have you retrieved the datasets ?
@thisislukefox
@thisislukefox 9 месяцев назад
The data can be located here: ourworldindata.org/coronavirus
@locomotech6302
@locomotech6302 Год назад
Thank you very much for the "core" of Excel and its powerful functions, we will try far from the Economist We respect you and "everyone who struggles to do good"... the programmer, the teacher, the soldier, the worker and the farmer. As for the Economist, who cares about the fraud (most of them) and his style? Indeed, in the days of sick globalization, many of them had a bad reputation (except for a few) in igniting high prices, underestimating the value of workers, and whistling the tables of the poor in order to flirt with greedy monsters. There is a lot of fraud on morals, so I do not see their relationship with style?
@thisislukefox
@thisislukefox Год назад
Appreciate the feedback!
Далее
Publication ready graphs in Microsoft Excel
10:14
Просмотров 18 тыс.
Best Toilet Gadgets and #Hacks you must try!!💩💩
00:49
Make Impressive McKinsey Visuals in Excel!
16:47
Просмотров 280 тыс.
How I replicated a combo chart from the Economist
14:38
7 Effective Tips for Presenting Data at Work!
7:32
Просмотров 146 тыс.
10 FREE Excel Add Ins to Boost Your Productivity
12:58
Просмотров 446 тыс.
How to make bar charts more interesting in excel
5:37
Просмотров 3,4 тыс.
Best Toilet Gadgets and #Hacks you must try!!💩💩
00:49