+ Reply to Thread
Results 1 to 3 of 3

Area Chart - How to change the order of the products

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Area Chart - How to change the order of the products

    The right chart is mine, the left chart is the book chart.

    As you see, the order of the products is different.

    How to make that order like in the one on the left?
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,651

    Re: Area Chart - How to change the order of the products

    Right click the plot area --> Change Chart Type --> Choose Stacked Area.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    12-07-2015
    Location
    delhi
    MS-Off Ver
    2010
    Posts
    80

    Re: Area Chart - How to change the order of the products

    Hi zanshin,

    Please find attached area chart excel file, i have created chart as per your requirements.

    Click *Add Reputation to say Thank and Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) If you are satisfied

    regards Imran.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to change plot area size of pivot chart
    By juamig in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-13-2016, 10:31 PM
  2. Replies: 5
    Last Post: 12-09-2015, 12:41 PM
  3. Change order of Legend without changing the order of the chart
    By Grimace in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-22-2012, 11:53 AM
  4. Products to Order
    By WDC3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 12:33 PM
  5. Stacked Area Chart Series Colour Change
    By downunderthunder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2010, 09:18 PM
  6. Change Plot Area in Relation to Whole Chart
    By driffert in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2008, 01:53 AM
  7. [SOLVED] Combination chart - area and column - order display?
    By Gary King in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2006, 04:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1