How to Change the Order of an Excel Stacked Area Chart (With Quick Steps)

 

How to Add a Stacked Area Chart in Excel

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

Electronic Sales Data

Steps:

  • Select your dataset, which is B5:E10 here.
  • Go to the Insert tab >> Insert Line or Area Chart tool >> Stacked Area option.

Insert a Stacked Area Chart

  • You will see a stacked area chart for your selected data range.

Stacked Area Chart of Dataset

  • To visualize the chart better, click on the Chart Elements tool and tick only the Axes and Legend options.

Access the Chart Elements Tool for a Better Visualization

  • To clarify the chart, right-click on the chart area and choose the Select Data… option from the context menu.

Access the Select Data Source Window

  • The Select Data Source window will appear.
  • Click on the Series 1 legend entry and click on the Edit button.

Edit the Data Series

  • The Edit Series window will appear now.
  • Type ‘Desktop’ in the Series name: text box, as this dataset represents the Desktop column data.
  • Click OK.

Rename the Series 1 Name

  • For Series 2 and 3, write ‘Laptop’ and ‘Mobile’.
  • Click on OK from the Select Data Source window.

Rename All the Names of the Series'

You can see you now have an understandable and better-looking stacked area chart of your dataset. It will look like this.

Stacked Area Chart in Default Order


How to Change Order of Stacked Area Chart in Excel (With Easy Steps)

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

  • Click on the chart area and right-click.
  • Choose the Select Data… option from the context menu.

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

  • The Select Data Source window will appear.

Read More: Excel Stacked Area Chart Negative Values


Step 2: Reorganize the Order of the Series

  • Select the Desktop series and click the downward arrow button twice.

Excel Stacked Area Chart Change Order

  • 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

  • Now, you can see that all the series are aligned as you want them.
  • Click OK.

Finalize the Changed Order of the Excel Stacked Area Chart

You can change the Excel stacked area chart order to your requirements. The outcome should look like this.

Excel Stacked Area Chart with Changed Order


Download the Practice Workbook

You can download and practice from our workbook here.


Related Articles


<< Go Back To Excel Area ChartExcel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo