Beautiful Excel Charts: All 11 Star Wars Box Office Revenue Ranked

beautiful-excel-charts-starwars-16x9

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

beautiful excel chart star wars ranked
All 11 Star Wars Box Office Revenue Ranked

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.

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.

Derek Leong

Derek Leong

Derek has over a decade of experience developing VBA applications in Microsoft Access and Microsoft Excel. He also conducts VBA programming classes occasionally.

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email
small_c_popup.png

Let's have a chat

Hello!

We are Aeternus Consulting.

We like to put our hands into a lot of things. We consult, develop applications, design presentations and teach.