+ Reply to Thread
Results 1 to 2 of 2

Change order of treemap components

  1. #1
    Registered User
    Join Date
    09-01-2020
    Location
    Berlin, Germany
    MS-Off Ver
    Latest
    Posts
    1

    Change order of treemap components

    Hello,

    Thank you for accepting me into this forum!

    For a presentation, I have to create a visual to size a European target market. Everything is how I want it to be, just the order of the components is backwards. I have searched through multiple forums and google the whole day yday and the deadline is fast approaching.

    I know that they are ordered by size and the data dictates the order, however I need the order to be going from smallest, to largest.

    For my example this would mean:

    1. Switzerland (Top Left)
    2. Germany (Right beneath Switzerland)
    3. EU (Next to 1 & 2)
    4. Europe (Next to EU)

    I have attached my workbook. I would be over the moon if somebody could help me solve this issue.

    Thank you for your time and understanding!!!

    Best,
    Paul
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Change order of treemap components

    Look's like that level of control is not available with the treemap chart
    Cheers
    Andy
    www.andypope.info

+ 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. Order of parent categories in Treemap chart incorrect
    By waynejohndavies1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-09-2020, 09:00 AM
  2. Replies: 3
    Last Post: 04-17-2019, 12:48 PM
  3. Count every time i change a components ID changes
    By ThommyN in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-02-2016, 06:02 PM
  4. [SOLVED] VBA to detect change in order number, then add a value to each 1st line of that order
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2013, 09:19 AM
  5. 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
  6. Running List of On Order Product Components
    By mhaslam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2011, 03:04 PM
  7. Locking components BUT Still allowing to change settings via VBA
    By Stan The Man in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2005, 11:05 AM

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