Heat Map Design Question

[PaulF]

Hello ALL !!

I am working on a dynamic heat map and have run into what I hope what is a simple question...

Based on a selection I use offset to pull in some numbers with conditional formatting based on some math to give me a heat view of when we are getting activity...

I only want to see the colors and NOT the data... Any suggestions ??

Respectfully,
./paulf

 

[Hui]

I think you need to setup a duplicate table beside/underneath your data table
The New Table has no values or formulas just the Headers
You apply the CF to that table but based on the values in the original table

If you post your file that will be appreciated

 

[NARAYANK991]

Hi Paul ,

Use the custom cell format ;;;

Narayan

 

[Khalid NGO]

Hi Paul,
After applying Narayan's suggestion your map will looks like:



Regards,

 

[PaulF]

I ended up keeping the numbers in as it makes the chart more effective, especially considering numbers can vary from .001 per hour on a day to 1,600+ (Depending on the selected queue)... I also added a group of option controls for YTD, Monthly, and Weekly view of the heat chart.