+ Reply to Thread
Results 1 to 4 of 4

Treemap colour not matching

  1. 09-19-2021, 08:37 AM #1
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,040

    Treemap colour not matching

    Hi all, need help to match colours of 2 treemaps with same series names, when one of the series values is zero.

    "Others" in 1st treemap is coloured in gold while it is light blue in 2nd treemap.

    Thanks in advance!

    Treemap Colour Not Matching.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-19-2021, 01:04 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Treemap colour not matching

    The colors are assigned by order in your list. Giant is skipped in the first chart because it is 0%. To manage this, sort your data descending by Sales.

    treemap.JPG
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 09-19-2021, 07:55 PM #3
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,040

    Re: Treemap colour not matching

    Thank you Jeff! it works perfectly!
    Reply With QuoteRegister To Reply
  4. 09-19-2021, 09:47 PM #4
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Treemap colour not matching

    Glad to help!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to find which Treemap box is selected.
    By aj34321 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-29-2020, 07:33 AM
  2. [SOLVED] extract range from Treemap chart
    By Eastw00d in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2020, 04:24 AM
  3. [SOLVED] Matching a single cell colour to the tab colour
    By tomo85 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-27-2019, 03:17 AM
  4. Treemap Issues
    By aglazar in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 04-24-2018, 07:59 AM
  5. Treemap for Excel 2013
    By mike_christopher in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-24-2016, 04:34 PM
  6. treemap
    By rodich in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2013, 05:34 AM
  7. Colour on Monitor not Matching Colour Printed
    By whisperingwillow in forum Excel General
    Replies: 11
    Last Post: 10-17-2011, 05:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1