Create Slopegraphs in Excel | Excel Off The Grid | Automate with a macro

Опубликовано: 11 Октябрь 2024
на канале: Excel Off The Grid
2,246
92

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Download the example file★
https://exceloffthegrid.com/the-ultim...


★ About this video ★
I’m not going to lie to you, the first time I saw a slopegraph I was completely underwhelmed, I thought “it’s a line chart with only two points, hardly worth getting excited about”. But the reaction I got the first time I used one in a presentation was unbelievable. People even asked me for my template, so they could create Slopegraphs themselves.

In this post, I want to show you how to create slopegraphs in Excel.

As the formatting can be quite time consuming, I've also created a macro to do it all in a single click... you're welcome 😀.


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel #VBA