Highlight the MAXIMUM and MINIMUM values ​​of your chart in EXCEL.

Опубликовано: 04 Июнь 2026
на канале: SMARTpro Academy
48,757
2.6k

👩🏻‍💻 Stand out with your reports, providing immediate information: automatically highlighting the MAX and MIN of your charts 👍😁.

00:00 INTRO
01:08 Step 1: Create a Chart with a Marker Line.
02:01 Step 2: Create a Series to Graph the Max and Min.
03:22 Step 3: Add a Custom Marker.
05:23 Learning the IF( ) Function.
07:05 Step 4: Apply the IF( ) Function to Get the MAX and MIN.
10:46 Step 5: Hide the Helper Columns.

-----------------------------------------------------------

LINKS to the referenced videos:
▶ Are you still making these "Tables" with borders in EXCEL?
   • ¿Todavía sigues haciendo estas “Tablas” co...  

-----------------------------------------------------------

👨‍💻 If you want to download the video file for practice, download it from the following link:
https://smartprosoluciones.com/resalt...
​
-----------------------------------------------------------

📒 Would you like to know your current level in EXCEL? Take our free test:
https://maraton.smartprosoluciones.co...
​

-------------------------------------------------------------

✅🚀 🅼 🅸 T R A I N G 🅞

DO YOU WANT TO CATAPULT YOUR EXCEL SKILLS 👩🏻‍💻 👨🏻‍💻 and STAND OUT FROM THE MASS OF PROFESSIONALS?

GREAT! Visit my academy's website for more information about my training:
https://www.smartprosoluciones.com/

---------------------------------------------------------------------------------------------------------

👨‍👨‍👧 LET'S STAY CONNECTED! 😁:
Instagram and Facebook: @SMARTpro Academy

► Instagram:   / smartproacademy  
► Facebook:   / smartproacademy  
► TikTok:   / smartproacademy  

---------------------------------------------------------------------------------------------------------

#excel #microsoftexcel #excelcreators #MicrosoftAmbassador