The Context
The Skywalker saga has come to an end. Star Wars: The Rise of Skywalker is the final installment in the space opera series, completing a story set in motion over 40 years ago by George Lucas.
The Data
Let’s look at the breakdown of every live-action theatrical release in the “Star Wars” universe, in the order of box office revenue worldwide (figures adjusted for inflation at 3% since 1980). Source: BoxOfficeMojo.com
Star Wars: Episode IV – A New Hope (1977) US$2684M
Star Wars: Episode VII – The Force Awakens (2015) US$2328M
Star Wars: Episode I – The Phantom Menace (1999) US$1855M
Star Wars: Episode V – The Empire Strikes Back (1980) US$1735M
Star Wars: Episode VIII – The Last Jedi (2017) US$1414M
Star Wars: Episode VI – Return of the Jedi (1983) US$1378M
Star Wars: Episode III – Revenge of the Sith (2005) US$1286M
Rogue One: A Star Wars Story (2016) US$1154M
Star Wars: Episode II – Attack of the Clones (2002) US$1073M
Star Wars: Episode IX – The Rise of Skywalker (2019) US$928M
Solo: A Star Wars Story (2018) US$405M
The Excel Chart
The fans have spoken and the numbers don’t lie. There was a lot of backlash when Disney bought Lucasfilm and hastily proceeded development of a sequel trilogy. Fans were incensed by the 2017 The Last Jedi release and the the box office results for Star Wars: Episode IX – The Rise of Skywalker are telling.
Excel Charting Technique Tips
Using a Bar Chart to preserve movie titles
To create the above chart, I have considered the movie titles are long and the best chart type to use would be a bar chart because the movie titles will be presented in a natural reading order.
Making rounded corner bars by using very thick borders
Usually the bars in a bar chart are always in rectangles. To create the rounded corner look, I used very thick borders and set the corners to be rounded.
Colouring the bar chart using Star Wars “red vs blue” theme
The borders for the bars are coloured using gradient colour at 0 degree angle ranging from pink to blue.
I have provided the actual Excel file for you to download and explore those chart settings on your own. This file by Aeternus Consulting is licensed under Creative Commons Licence Attribution-NonCommercial 4.0 International.
About Aeternus Consulting
Related Link: Aeternus Consulting Excel Training Courses Singapore
Aeternus Consulting offers an excellent workshop Storytelling with Data Visualization using Beautiful Excel Charts. This workshop is aimed at students visualizing thesis data, managers and analysts needing to communicate in a data-driven way and leaders informing their board to drive actions.
Related Link: Making Charts Beautiful with Microsoft Excel
