Skip to content

enhancing
the defaults 003:
left aligned axis

Left aligned or right aligned? Which one is better? It depends (as usual in data graphics). Let’s begin how to set it up in with Excel charts:

 

download file

Links mentioned in the video:

      1. WSJ Graphics on X: 
      2. does one left-justify the text in an Excel horizontal bar chart axis label?
      3. Monday Morning Mulling: January 2018 < Blog by SUMPRODUCT.com
      4. Left Align Vertical Axis (excelforum.com)
      5. Arial Monospaced MT Free Font Download (No Signup Required) (fontsplace.com)

If you have any questions or suggestions, let me know in the comments section on the YouTube video above.

For consulting inquiries, please direct message me on LinkedIn. Thank you.

Below are real examples in the wild of charts with left aligned axis:

source: https://blog.datawrapper.de/new-years-resolutions-topics/


source: https://www.nytimes.com/2022/05/26/briefing/guns-america-shooting-deaths.html


source: https://www.nytimes.com/2019/09/26/learning/whats-going-on-in-this-graph-oct-2-2019.html


source: https://www.wsj.com/articles/americans-pull-back-from-values-that-once-defined-u-s-wsj-norc-poll-finds-df8534cd


source: https://www.wsj.com/personal-finance/the-exact-age-when-you-make-your-best-financial-decisions-2a8163bb


source: https://www.wsj.com/economy/us-gdp-economy-third-quarter-f247fa45



source: https://www.wsj.com/articles/how-ai-is-catapulting-nvidia-toward-the-1-trillion-club-14f42380


source: https://www.economist.com/graphic-detail/2022/09/08/elizabeth-ii-was-the-longest-reigning-monarch-in-british-history


source: https://www.economist.com/special-report/2023/03/20/how-digital-gaming-spreads-far-and-wide


Source: https://www.wsj.com/articles/the-covid19-crisis-is-officially-over-everything-changed-605b31ae?mod=e2tw


Source: https://www.theguardian.com/uk-news/2022/dec/16/snow-chance-how-a-white-christmas-has-become-less-likely-in-britain


Source: https://www.economist.com/graphic-detail/2022/11/11/how-much-money-is-needed-to-fight-climate-change


Source: https://www.theguardian.com/uk-news/2022/nov/02/one-in-six-people-living-england-wales-were-born-different-country-census-reveals


Source: https://www.bloomberg.com/news/live-blog/2022-10-27/brazil-presidential-election-runoff


Source: https://www.economist.com/graphic-detail/2022/11/04/our-midterm-predictions-point-to-major-gains-for-the-republicans


Source: https://www.propublica.org/article/yieldstar-rent-increase-realpage-rent


Source: https://fivethirtyeight.com/features/how-democrats-and-republicans-think-differently-about-crime-and-gun-violence/


Source: https://www.spiegel.de/wissenschaft/markus-soeder-sieht-bayern-beim-ausbau-erneuerbarer-energien-vorne-ein-faktencheck-in-daten-und-statistiken-a-89c687cc-a195-4c9e-a9f9-53ecbf51f2da?sara_ecid=soci_upd_KsBF0AFjflf0DZCxpPYDCQgO1dEMph


Source: https://elpais.com/clima-y-medio-ambiente/2022-07-24/olas-de-calor-lo-que-viene-es-peor.html


Source: https://www.szabadeuropa.hu/a/abrakon-mutatjuk-meg-hogyan-tuntetne-el-az-osszes-szivarvanyt-a-kormany/31929828.html


Source: https://www.economist.com/graphic-detail/2022/07/13/which-covid-19-vaccine-saved-the-most-lives-in-2021


Source: https://www.thetimes.co.uk/article/held-back-the-mothers-who-cant-afford-to-return-to-work-r5r3k9bxl


Source: https://www.nytimes.com/2022/06/03/upshot/gun-control-polling-votes.html


Source: https://www.thetimes.co.uk/article/america-s-battle-with-gun-violence-in-maps-and-charts-sjl083fcf


Source: https://www.economist.com/graphic-detail/2022/05/20/why-the-crypto-crash-hit-black-americans-hard


Source: https://fivethirtyeight.com/features/the-real-dividing-line-on-abortion/


Source: https://www.eldiario.es/economia/aumentan-hogares-ingreso-minimo-vital-ayuda-cubre-mitad-pobreza-extrema_1_10972664.html


Source: https://www.eldiario.es/economia/mapa-precio-alquiler-calle-calle-descubre-vivir-gastar-tercio-ingresos_1_10798087.html


Source: https://www.economist.com/graphic-detail/2022/04/19/how-chinas-sinovac-compares-with-biontechs-mrna-vaccine


Source: https://www.sfchronicle.com/bayarea/article/lowell-high-admissions-17110235.php


Source: https://www.washingtonpost.com/food/2024/03/14/irish-pub-names/


Source: https://www.elmundo.es/economia/ahorro-y-consumo/2022/02/11/62052950e4d4d86d798b45aa.html


Source: https://www.economist.com/graphic-detail/2022/02/10/americans-want-reforms-to-curb-gerrymandering-our-new-poll-shows


Source: https://www.economist.com/graphic-detail/2022/01/20/covid-19-vaccines-have-made-americans-less-anxious-and-depressed


Source: https://elpais.com/sociedad/2022-01-15/el-exito-de-las-vacunas-contra-omicron-los-vacunados-tienen-cinco-veces-menos-probabilidad-de-ingresar-en-un-hospital.html


Source: https://yougov.co.uk/entertainment/articles/49316-eurotrack-who-is-watching-eurovision-2024-and-why


see more vlog-posts