www.exceldemy.com
Open in
urlscan Pro
2606:4700:3030::ac43:9a99
Public Scan
URL:
https://www.exceldemy.com/excel-stacked-bar-chart-reverse-legend-order/
Submission: On December 07 via api from US — Scanned from DE
Submission: On December 07 via api from US — Scanned from DE
Form analysis 4 forms found in the DOM
GET https://www.exceldemy.com/
<form role="search" method="get" class="search-form" action="https://www.exceldemy.com/">
<input type="text" name="s" placeholder="Search" data-posttype="post">
<input type="hidden" name="post_type" value="post"> <button type="submit" class="btnsearch hideonmobile" aria-label="Search"><i class="rhicon rhi-search"></i></button>
</form>POST https://www.exceldemy.com/wp-comments-post.php
<form action="https://www.exceldemy.com/wp-comments-post.php" method="post" id="commentform" class="comment-form"><textarea id="comment" name="comment" cols="30" rows="10" aria-required="true" aria-label="comment"></textarea>
<div class="usr_re"><input id="author" type="text" value="" name="author" placeholder="Name"></div>
<div class="email_re"><input id="email" type="text" value="" name="email" placeholder="E-mail"></div>
<div class="site_re end"><input id="url" type="text" value="" name="url" placeholder="Website"></div>
<div class="clearfix"></div>
<p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Submit"> <input type="hidden" name="comment_post_ID" value="170981" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
</p>
<p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="d8af79c31a"></p>
<p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="149">
<script type="rocketlazyloadscript">document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() );</script>
</p>
</form>POST
<form class="cpro-form" method="post">
<input type="hidden" class="panel-settings" data-style_id="382411" data-section="configure"
value="{"enable_custom_cookies":"","enable_cookies_class":"","enable_adblock_detection":"","enable_visitors":"","visitor_type":"first-time","referrer_type":"hide-from","hide_custom_cookies":"","hide_cookies_class":"","show_for_logged_in":"1","hide_on_device":"","cookies_enabled":"1","conversion_cookie":"365","closed_cookie":"30","cookies_enabled_submit":"","enable_cookies_class_submit":"","conversion_cookie_submit":"90","cookies_enabled_closed":"","enable_cookies_class_closed":"","closed_cookie_new":"30"}"><input
type="hidden" class="panel-rulesets" data-style_id="382411" data-section="configure"
value="[{"name":"Ruleset 1","autoload_on_duration":"0","load_on_duration":1,"autoload_on_no_page_visit":false,"load_on_no_page_visit":1,"load_on_page_visit_type":"is-more-than","cp_show_note_page_view":"","modal_exit_intent":false,"autoload_on_scroll":"0","load_after_scroll":"35","inactivity":false,"inactivity_link":"","enable_after_post":false,"enable_custom_scroll":false,"enable_scroll_class":"","on_scroll_txt":"","show_cta_info":"","enable_custom_cookies":false,"enable_cookies_class":"","on_cookie_txt":"","hide_cta_link":"","enable_adblock_detection":false,"all_visitor_info":"","enable_visitors":"","visitor_type":"first-time","enable_referrer":"","referrer_type":"hide-from","display_to":"","hide_from":"","enable_scheduler":false,"enable_scheduler_txt":"","start_date":"","end_date":"","custom_cls_text_head":"","enable_custom_class":"1","copy_link_code_button":"Copy Link Code","copy_link_cls_code_button":"","custom_class":"sample101","custom_cls_text":""}]">
<style id="cp_popup_style_382411" type="text/css"></style>
<div class="cp-popup-content cpro-active-step cp-modal_popup cp-panel-1" data-entry-animation="cp-fadeIn" data-overlay-click="1" data-title="Advanced Excel Exercises with Solutions" data-module-type="modal_popup" data-step="1"
data-width="600" data-mobile-width="320" data-height="400" data-mobile-height="280" data-mobile-break-pt="767" data-mobile-responsive="yes">
<div class="cpro-form-container">
<div id="cp_close_image-2-382411" class="cp-field-html-data cp-none cp-image-ratio cp-close-field cp-close-image-wrap" data-type="cp_close_image" data-field-title="Close Image" data-action="close">
<div class="cp-rotate-wrap">
<div class="cp-image-main"><img loading="lazy" width="45" height="45" data-cp-src="https://www.exceldemy.com/wp-content/plugins/convertpro/assets/admin/img/close2.png" class="cp-target cp-field-element cp-close-image cp-img-lazy" alt=""
name="cp_close_image-2" value="" src="">
<div class="cp-field-shadow"></div>
</div>
</div>
</div>
<div id="cp_heading-2-382411" class="cp-field-html-data cp-none cp_has_editor" data-type="cp_heading">
<div class="cp-rotate-wrap">
<div class="cp-target cp-field-element cp-heading tinymce" name="cp_heading-2">
<p>Advanced Excel Exercises with Solutions PDF</p>
<p> </p>
<p> </p>
</div>
</div>
</div>
<div id="cp_email-3-382411" class="cp-field-html-data cp-none" data-type="cp_email">
<input type="email" class="cp-target cp-field-element cp-form-input-field cp-form-field cp-email cp-form-field cp-email-field" aria-label="Email Address" placeholder="Email Address" name="param[email]" value="" required="required"
data-email-error-msg="{{email-error}}" autocomplete="on">
</div>
<div id="cp_text-3-382411" class="cp-field-html-data cp-none" data-type="cp_text" data-field-title="Text">
<input type="text" class="cp-target cp-field-element cp-text cp-form-field cp-form-input-field cp-text-field" aria-label="First Name" placeholder="First Name" name="param[textfield_2832]" value="" access_cp_pro="" autocomplete="on">
</div>
<div id="cp_button-3-382411" class="cp-field-html-data cp-none" data-type="cp_button" data-action="submit_n_close" data-step="1">
<div class="cp-rotate-wrap"><button type="submit" class=" cp-target cp-field-element cp-button cp-button-field" data-success-message="SUCCESS! Watch your inbox for free exercises with solutions." data-get-param="false">YES, I WANT
THIS</button>
<div class="cp-btn-tooltip"></div>
</div>
</div>
<div id="cp_image-1-382411" class="cp-field-html-data cp-none cp-image-ratio" data-type="cp_image" data-action="none" data-step="1">
<div class="cp-rotate-wrap">
<div class="cp-image-main"><img loading="lazy" width="175" height="277" data-cp-src="https://www.exceldemy.com/wp-content/uploads/2023/05/book_cover.png" class="cp-img-lazy cp-target cp-field-element cp-image" name="cp_image-1" alt=""
src="">
<div class="cp-field-shadow"></div>
</div>
</div>
</div>
</div>
</div>
<input type="hidden" name="param[date]" value="Dec 7, 2023">
<input type="text" class="cpro-hp-field" name="cpro_hp_field_382411" value="">
<input type="hidden" name="action" value="cp_v2_add_subscriber">
<input type="hidden" name="style_id" value="382411">
</form>GET https://www.exceldemy.com/
<form role="search" method="get" class="search-form" action="https://www.exceldemy.com/">
<input type="text" name="s" placeholder="Search" data-posttype="post">
<input type="hidden" name="post_type" value="post"> <button type="submit" class="btnsearch hideonmobile" aria-label="Search"><i class="rhicon rhi-search"></i></button>
</form>Text Content
Submit Excel Task Exceldemy Forum * Home * About Us * Blog * Excel Basics * Excel Functions * Excel Formulas * Macros & Excel VBA * Advanced Excel * Excel Charts * Data Analysis with Excel * Excel Pivot Table * Excel Power Query * Excel Solver * Excel for Finance * Learn VBA * Excel Practice * Advanced Excel Exercises * Calculation with Excel Formulas * Excel Training & Courses * Interview Questions with Excel Topics * MCQ Questions on MS Excel * Practice Test & Quiz * Practice with VBA * Use of Excel Functions * Books * Forum * ExcelDemy Online Training * Create Basic Excel Pivot Tables * Excel Formulas and Functions * Excel Charts and SmartArt Graphics * Advanced Excel Training * Data Analysis Excel for Beginners * ExcelDemy Consultancy * Pricing * Services List * Submit Your Task * User Reviews Home » Excel Charts » Reverse Legend Order of Stacked Bar Chart in Excel (With Quick Steps) REVERSE LEGEND ORDER OF STACKED BAR CHART IN EXCEL (WITH QUICK STEPS) Written by Mursalin Ibne Salehin Last updated: Oct 29, 2023 Get FREE Advanced Excel Exercises with Solutions! In this article, we will learn to reverse the legend order of a stacked bar chart in Excel. A stacked bar chart is a graph that uses bars to show different data. Generally, it is used to break down and compare different parts of a whole. Today, we will demonstrate step-by-step procedures to reverse the legend order of the stacked bar chart in Excel. So, without any delay, let’s start the discussion. -------------------------------------------------------------------------------- Table of Contents hide Excel Stacked Bar Chart Reverse Legend Order: Step-by-Step Procedures STEP 1: Create Stacked Bar in Excel STEP 2: Open Context Menu and Select Data STEP 3: Reverse Position of Legend Entries Final Output Change Legend Order of Stacked Column Chart in Excel Conclusion Related Articles EXCEL STACKED BAR CHART REVERSE LEGEND ORDER: STEP-BY-STEP PROCEDURES To explain the steps, we will use a dataset that contains the sales amount of some Salesmen for January, February, and March. We will create a stacked bar chart using these values and then, try to reverse the legend order. MY LATEST VIDEO Top Excel Skills You Need to Get Hired 0 seconds of 1 minute, 42 secondsVolume 0% Press shift question mark to access a list of keyboard shortcuts Keyboard ShortcutsEnabledDisabled Play/PauseSPACE Increase Volume↑ Decrease Volume↓ Seek Forward→ Seek Backward← Captions On/Offc Fullscreen/Exit Fullscreenf Mute/Unmutem Decrease Caption Size- Increase Caption Size+ or = Seek %0-9 Live 00:00 01:42 01:42 -------------------------------------------------------------------------------- STEP 1: CREATE STACKED BAR IN EXCEL * In the first place, create a stacked bar in Excel. * To do so, select all the cells of the dataset. * After that, go to the Insert tab and select the Insert Column or Bar Chart icon. A drop-down menu will appear. * Select 2-D Stacked Bar from there. * Instantly, a 2-D Stacked Bar will appear on the Excel sheet. Read More: How to Change Bar Chart Color Based on Category in Excel -------------------------------------------------------------------------------- STEP 2: OPEN CONTEXT MENU AND SELECT DATA * Secondly, right–click on the chart to open the Context Menu. * In the Context Menu, click on the Select Data option. * It will open the Select Data Source window. Read More: How to Color Bar Chart by Category in Excel -------------------------------------------------------------------------------- STEP 3: REVERSE POSITION OF LEGEND ENTRIES * Thirdly, you need to reverse the position of the legend entries. * In our case, the order of the legends is January, February, and March. * In order to reverse the order, select January and click on the drop–down arrow twice in the Legend Entries section. * Again, select February and click on the drop–down arrow once. * After that, the order in the Legend Entries will be March, February, and January. * Press OK. -------------------------------------------------------------------------------- FINAL OUTPUT * Finally, after clicking OK, you will see the reverse legend order of the stacked bar chart. -------------------------------------------------------------------------------- CHANGE LEGEND ORDER OF STACKED COLUMN CHART IN EXCEL In this section, we will learn to change the legend order of the stacked column chart in Excel. We will use the manual method here. To explain this process, we will use the previous dataset but we will consider the first two months only. The stacked column chart of the above dataset looks like the graph below. Let’s observe the steps below to learn more about the method. STEPS: * Firstly, create duplicate columns for February and January with zeros in Columns C and D respectively. * Remember, the duplicate columns should be in reverse order. * Secondly, fill in the sales amount for February and January. * After that, select the range B4:D11. * In the following step, navigate to the Insert tab and select the Insert Column or Bar Chart icon. A drop-down menu will appear. * Select the Stacked Column icon from there. * Finally, you will see the change in the legend order of the stacked column chart in Excel. Read More: How to Add Grand Total to Bar Chart in Excel -------------------------------------------------------------------------------- Download Practice Workbook You can download the practice book from here. Reverse Legend Order of Stacked Bar Chart.xlsx -------------------------------------------------------------------------------- CONCLUSION In this article, we have demonstrated step-by-step procedures to Reverse the Legend Order of a Stacked Bar Chart in Excel. I hope this article will help you to perform your tasks easily. Moreover, we have also added the practice book at the beginning of the article. Furthermore, you can download it to test your skills. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below. -------------------------------------------------------------------------------- RELATED ARTICLES * How to Create Bar Chart with Error Bars in Excel * How to Sort Bar Chart in Descending Order in Excel * Excel Bar Graph Color with Conditional Formatting * Excel Add Line to Bar Chart * How to Add Horizontal Line to Bar Chart in Excel * How to Add Vertical Line to Excel Bar Chart * How to Create Bar Chart with Target Line in Excel * Excel Bar Chart with Line Overlay WHAT IS EXCELDEMY? ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. SaveSavedRemoved 0 Tags: Excel Bar Chart Mursalin Ibne Salehin Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics. We will be happy to hear your thoughts LEAVE A REPLY CANCEL REPLY Δ EXCLUSIVE EXCEL TUTORIALS Make a Pie Chart in Excel (5 Examples) -------------------------------------------------------------------------------- VLOOKUP from Another Sheet in Excel -------------------------------------------------------------------------------- Excel Advanced Filter (5 Applications) -------------------------------------------------------------------------------- Make a Gantt Chart in Excel -------------------------------------------------------------------------------- INDEX MATCH vs VLOOKUP Function -------------------------------------------------------------------------------- Find External Links in Excel -------------------------------------------------------------------------------- Goal Seek Analysis in Excel -------------------------------------------------------------------------------- Recover Corrupted Excel File -------------------------------------------------------------------------------- SUMIFS to SUM Values in Date Range in Excel -------------------------------------------------------------------------------- Formula for Number of Days Between Two Dates About ExcelDemy.com ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Contact | Privacy Policy | TOS ExcelDemy Consulting Services * Excel Consultancy Services * User Reviews * List of Services * Service Pricing Submit Excel Task See Our Review at ExcelDemy Online Training * ExcelDemy Online Training * Create Basic Excel Pivot Tables * Excel Formulas and Functions * Excel Charts and SmartArt Graphics * Advanced Excel Training * Data Analysis Excel for Beginners Follow Us Join ExcelDemy Forum Copyright © 2013-2023 ExcelDemy.com | All rights reserved This website is owned and published by SOFTEKO Advanced Excel Exercises with Solutions PDF YES, I WANT THIS Submit Excel Problem * Submit Excel Problem * Home * About Us * Blog * back * Excel Basics * Excel Functions * Excel Formulas * Macros & Excel VBA * Advanced Excel * Excel Charts * Data Analysis with Excel * Excel Pivot Table * Excel Power Query * Excel Solver * Excel for Finance * Learn VBA * Excel Practice * back * Advanced Excel Exercises * Calculation with Excel Formulas * Excel Training & Courses * Interview Questions with Excel Topics * MCQ Questions on MS Excel * Practice Test & Quiz * Practice with VBA * Use of Excel Functions * Books * Forum * ExcelDemy Online Training * back * Create Basic Excel Pivot Tables * Excel Formulas and Functions * Excel Charts and SmartArt Graphics * Advanced Excel Training * Data Analysis Excel for Beginners * ExcelDemy Consultancy * back * Pricing * Services List * Submit Your Task * User Reviews * Update Privacy Preferences A Raptive Partner Site