Premium Only Content

This Excel Chart will grab your attention (Infographic template included)
Feb 19, 2017 Excel Infographic Chart Templates
Learn how to create Excel graphs that are different to the norm but still visually effective. They are great to include in special reports and dashboards. Note: This technique is a part of my online Dashboard course.
★ Complete Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards
Timestamps
00:00 Why Create a Non-Standard Column Chart in Excel
01:48 Start with Basic Column Chart
02:44 Conditional Formatting of Excel Column Chart for MAX-Value
05:51 Create Round Shape for Excel Column Chart
07:45 Prevent Stretching of Round Shape in Column Chart
10:41 Add Data Labels to Excel Chart
12:45 Add Conditional Formatting to Rounded Column Chart
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
⯆ Download the workbook here: http://bit.ly/2rCXXrE
The link to the original report I mention in the video - https://business.udemy.com/blog/learning-predictions-2017/
This video shows you how to create special (non-standard) Excel graphs or info-charts in Excel. Not only that but it also shows you how you can conditionally format your graph to highlight specific categories. In this example, I show you how to highlight the week day that has the most users logged on to a system, but you can apply the same technique to any other logic as well.
After that, I show you how you can add shapes to charts. This attracts the attention of your readers because it's different to what they are used to seeing. The problem with this technique is that it stretches out the shape for the bigger data sets so depending on the shape you are using, they are no longer harmonized.
As a last step, I show you a trick you can use to create harmonized shapes in your Excel graphs. It's all a matter of proper data preparation before you draw out the chart.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
LIVE
Viss
1 hour ago🔴LIVE - How to Consistently Win in PUBG!
106 watching -
LIVE
GloryJean
2 hours agoSniping & Dominating Solos 🖱️ 6.7 K/D
44 watching -
1:40:15
Nikko Ortiz
2 hours agoLive - News, Politics, Podcast And Naaah Im Playin We Chillen
18.8K4 -
1:02:10
VINCE
4 hours agoWhat Just Happened At The White House? | Episode 106 - 08/19/25
163K170 -
LIVE
LFA TV
5 hours agoLFA TV ALL DAY STREAM - TUESDAY 8/19/25
4,326 watching -
1:18:04
The Big Mig™
5 hours agoTrump, NO More Voter Fraud It’s Time, LFG
17K10 -
DVR
The State of Freedom
7 hours ago $0.42 earned#325 Running an America-First Campaign w/ Sammy Wyatt
48.6K2 -
1:50:16
Dear America
4 hours agoTrump Calls Putin MID-MEETING With World Leaders!! Did Trump just END THE WAR?!
105K64 -
LIVE
GritsGG
4 hours agoWin Streaking! Most Wins 3390+ 🧠
105 watching -
2:03:23
Matt Kohrs
11 hours agoLIVE! Day Trading Futures & Options || Market Open
38.2K1