My feedback

1. Conditional format coloring for Treemap chart

   73 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   4 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thank you for the suggestion on conditional format coloring for treemap charts! While we don’t expect to devote time to this in the near future, we will continue tracking votes and comments here. We will keep this suggestion under consideration for future development.

   Thank you again,
   Auston [MSFT]

   An error occurred while saving the comment
   Don Simard commented  ·  August 15, 2017  ·  Edit…  ·  Delete…

   @shuvro-basu
   in your code snippet - what is "x"? it is undeclared. Will it be the loop index that you didn't implement?

   If ActiveChart.FullSeriesCollection(1).Points(x + 1).DataLabel.Text = "Type-DataLabel-That-You-Want" Then

   ActiveChart.FullSeriesCollection(1).Points(x + 1).Select
   ActiveChart.FullSeriesCollection(1).Points(x + 1).Format.Fill.ForeColor.RGB = NEG_COLOR

   Save Submitting...