Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Heatmap Graphic Enhanced

Posted on 2015-01-27
3
83 Views
Last Modified: 2015-01-27
EE Pro. Phillip Burton helped me build out a Cycle Heatmap using a macro.  Now I'm trying to intergrate it into a larger Heatmap.  Part of the Map is based on Conditional Formatting (the non-cycle part). The Part Phillip helped me with is based on a Macro in the Sheet (starting at S32-S38) and monitors the score (1-3) to indicate the colors.

Here's what I need;

1.) How do I make the arrows solid instead of transparent?
2.) How do I get rid of error?

Thank you in advance,

B.
D--Data-Data-Temp-Cycle-Heatmap-Extended
0
Comment
Question by:Bright01
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40572564
Problem 1 - Right-hand click on the arrow, Format Shape, go to Fill and change the Transparency to 0%.

Problem 2 - Change

"Arrow" & (Target.Row) - 1

to

"Arrow" & (Target.Row) - 31
0
 

Author Closing Comment

by:Bright01
ID: 40572963
Great!  Works perfectly.  Appreciate the elegant solution and rapid response!

All the best,

B.
0
 

Author Comment

by:Bright01
ID: 40573114
Authored another question to get to the next level on this.  Hope you can take a look.

B.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Turn date into age 17 32
A Table within a User Form 24 43
Excel Split Employee Name into Lname Fname Mname 3 15
Excel VBA 30 38
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question