Image Custom Heatmap in Excel using Macros

  Рет қаралды 4,641

Micah Garcia

Micah Garcia

Күн бұрын

Tutorial on creating custom user-defined heatmap regions on an image using Macro-enabled excel workbook.
NOTE: macros are not functional on GoogleSheets or OnlineExcel

Пікірлер: 9
@yeahx32p69
@yeahx32p69 3 жыл бұрын
Thank you so much for this. Finally, I and my buddies can use this for our workouts. (More pain = more muscle gain in those body regions). Just have to record more data from the weight scale for higher accuracy. Going to use this for medical reasons as well for older folks. Can reveal patterns maybe. Using those patterns, future issues could be avoided too. I'm really thankful for what you have shown. It was so simple and to the point. Really helpful. Looking forward to more interesting things you show.
@SergioMCoach
@SergioMCoach 4 жыл бұрын
Thaaaank you :)
@0x647A
@0x647A 4 жыл бұрын
awesome!
@ericroodhooft973
@ericroodhooft973 2 жыл бұрын
Dear, thank you for the tutorial, but could you help me, I created the macro as described in your video. But when I try to run it, I always get the following error message error -2147024809 (80070057) during execution The item with the specified name was found nit ActiveSheet.Shapes(Range("actlocation"). Value). Fill.ForeColor.RGB = _ Range(Range("actcolorcode"). Value). Interior.color
@eleashaxox8158
@eleashaxox8158 3 жыл бұрын
Hello, thank you for the video. Really helpful. I am coming across an issue with running the macro. ActiveSheet.Shapes(Range("actlocation").Value).Fill.ForeColor.RGB = _ Range(Range("actcolourcode").Value).Interior.Color The above code is constantly being highlighted and coming up as an error saying 'Run time error'1004'. Method 'Range; of object'_Global' failed. Was just wondering if you could please help with this.
@yeahx32p69
@yeahx32p69 3 жыл бұрын
have you solved this issue? Did you try indexing the second line?
@munkie2003
@munkie2003 2 жыл бұрын
I have the same issue, how did you overcome this?
@8dasc
@8dasc Жыл бұрын
Same here. Has someone found a solution?
@om8367
@om8367 2 ай бұрын
Did anyone get it ryt?
How to Make an Interactive Body Map in Excel (No Macros Needed)
52:15
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 153 М.
Electric Flying Bird with Hanging Wire Automatic for Ceiling Parrot
00:15
А ВЫ ЛЮБИТЕ ШКОЛУ?? #shorts
00:20
Паша Осадчий
Рет қаралды 7 МЛН
Build Heatmaps on top of Custom Images
4:26
Oracle Analytics
Рет қаралды 8 М.
10 awesome Power Query tricks you NEED to know! | Excel Off The Grid
15:44
Excel Off The Grid
Рет қаралды 41 М.
No, Einstein Didn’t Solve the Biggest Problem in Physics
8:04
Sabine Hossenfelder
Рет қаралды 203 М.
Generating Professional Two-Dimensional Graphics in MATLAB
27:50
Making a dynamic map in MS Excel
7:04
Geo Guru
Рет қаралды 13 М.
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
Kenji Explains
Рет қаралды 408 М.
Dynamic Heat Map with Excel using Scroll Bar & Conditional Formatting
5:13
🌍 How to make interactive Excel Map charts
12:53
Kevin Stratvert
Рет қаралды 299 М.
Heat map using Excel 3D Power Map
5:56
Dr. Jayanta Das
Рет қаралды 1,9 М.
Electric Flying Bird with Hanging Wire Automatic for Ceiling Parrot
00:15