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
-
1:57:48
The Charlie Kirk Show
2 hours agoTrump Gets His Cabinet + Killing the USAID Grift + Why Bud Light Collapsed | Frericks | 2.4.2025
91.2K26 -
1:21:47
Simply Bitcoin
2 hours ago $1.05 earnedDid America JUST Change The Bitcoin Nation State Race Forever?! | EP 1175
12.5K1 -
37:13
Grant Stinchfield
2 hours ago $1.21 earnedBill Gates is Making the Media Rounds Today to Push the Vax and Stop RFK Jr.
8.02K16 -
DVR
TheAlecLaceShow
4 hours agoGuest: Rep. Burgess Owens | Trump Wins with Mexico & Canada | DNC Diversity | The Alec Lace Show
6.17K5 -
1:00:28
The Dan Bongino Show
5 hours agoTrump’s Most Important Fight To Date (Ep. 2415) - 02/04/2025
603K1.09K -
59:44
The Rubin Report
3 hours agoPress Gasps When Shown What USAID Spent Money On
77.3K117 -
1:15:21
Bare Knuckle Fighting Championship
4 hours agoThe Bare Knuckle Show with Brian Soscia
13.7K3 -
1:28:32
The Shannon Joy Show
4 hours ago🔥SHOCK Report - The COVID Dossier! A Coordinated Global Military Operation: Live EXCLUSIVE W/ Sasha Latypova & Debbie Lerman.🔥
12.8K2 -
1:57:04
Steven Crowder
5 hours agoUSAID Exposed: Everything You Need to Know Featuring Mike Benz
363K217 -
2:01:57
LFA TV
18 hours agoCLEANING HOUSE!! | LIVE FROM AMERICA 2.4.25 11am
66.1K20