Change Order of Excel Stacked Area Chart (with Quick Steps)

The stacked area chart is one of the handiest tools in Excel to visualize a large dataset easily. You can understand the contribution of each category of the whole dataset through this chart. Now, it might be needed frequently to change your chart order. In this article, I will show you detailed steps to change the order of an Excel stacked area chart.


Download Practice Workbook

You can download and practice from our workbook here for free!


How to Add a Stacked Area Chart in Excel

Suppose, you have a dataset of 6 months’ sales data of an electronic store. Now, you can create a stacked area chart in Excel using these data by following the steps below.

Electronic Sales Data

📌 Steps:

  •  First and foremost, select your dataset which is B5:E10 here. Afterward, go to the Insert tab >> Insert Line or Area Chart tool >> Stacked Area option.

Insert a Stacked Area Chart

  • As a result, you will see that there is a stacked area chart for your selected data range.

Stacked Area Chart of Dataset

  • Now, for better visualization of the chart, click on the Chart Elements tool and tick only the Axes and the Legend options.

Access the Chart Elements Tool for a Better Visualization

  • Now, your legends are not so understanding as they are named Series1,2 and 3. To overcome this, right-click on the chart area and choose the Select Data… option from the context menu.

Access the Select Data Source Window

  • Consequently, the Select Data Source window will appear. Following, click on the Series 1 legend entry and click on the Edit button.

Edit the Data Series

  • As a result, the Edit Series window will appear now. Write Desktop at the Series name: text box, as this dataset is representing the Desktop column data. Last but not least, click on the OK button.

Rename the Series 1 Name

  • Similarly, for Series 2 and 3, write Laptop and Mobile respectively. Finally, click on the OK button from the Select Data Source window.

Rename All the Names of the Series'

Thus, you can see you have an understandable and better-looking stacked area chart of your dataset now. For example, it would look like this.

Stacked Area Chart in Default Order


Steps to Change Order of Stacked Area Chart in Excel

Now, suppose, you want to change the order of the stacked area chart. Say, you want to show the Mobile data first, Laptop data second, and Desktop data last. Follow the steps below to do this.

📌 Step 1: Right-Click on Chart Area and Navigate to Select Data Source Window

  • At the very beginning, click on the chart area and right-click on your mouse. Following, choose the Select Data… option from the context menu.

Access the Select Data Source Window to Change Order of Excel Stacked Area Chart

  • Consequently, the Select Data Source window will appear.

Read More: How to Create Stacked Area Chart with Negative Values in Excel


📌 Step 2: Reorganize Order of Series

Say, you want to put the Mobile data first, Laptop data second, and Desktop data last. To do this, select the Desktop series and click the downward arrow button twice.

Excel Stacked Area Chart Change Order

  • Afterward, select the Mobile series and click on the upward arrow button.

Excel Stacked Area Chart Change Order

Read More: Excel Area Chart Data Label & Position


📌 Final Step: Finalize the Series Order and Press OK

  • Now, you can see all the series’ are aligned as you want. Finally, click on the OK button.

Finalize the Changed Order of the Excel Stacked Area Chart

Thus, you can change the Excel stacked area chart order as your requirements. For instance, the outcome should look like this.

Excel Stacked Area Chart with Changed Order

Read More: Stacked Area Chart with Line in Excel (2 Practical Examples)


Conclusion

To conclude, in this article, I have shown detailed steps to change the order of an Excel stacked area chart. I would suggest you go through the full article carefully and practice thoroughly. You can also download our practice workbook from here for free. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to comment here.
And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo