Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Heatmap Graphic Enhanced

Posted on 2015-01-27
3
Medium Priority
?
91 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
[X]
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
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

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 article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

704 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