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

This is a Microsoft Excel chart showing All 11 Star Wars Box Office Revenue Ranked.

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:

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.

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

excel courses in singapore
Advanced Excel Training Courses Classes Singapore: making beautiful charts

Leave a Reply

Your email address will not be published. Required fields are marked *