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:47:05
Drew Hernandez
9 hours agoISRAEL PLANNING POSSIBLE DRAFT IN USA & TRUMP'S VIEW ON ETERNAL LIFE ANALYZED
26.4K58 -
29:55
Afshin Rattansi's Going Underground
3 days agoProf. Omer Bartov: The REAL REASON the US, UK, and EU Have Not Recognised Israel’s Genocide in Gaza
23.6K26 -
LIVE
SpartakusLIVE
7 hours agoWednesday WZ with the Challenge MASTER || Duos w/ GloryJean
472 watching -
2:36:12
Barry Cunningham
6 hours agoREACTING TO STEPHEN MILLER | KASH PATEL | TULSI GABBARD INTERVIEWS AND MORE NEWS!
72.2K67 -
DVR
Alex Zedra
4 hours agoLIVE! Solo Scary Game night
28.2K -
58:01
MattMorseTV
6 hours ago $10.39 earned🔴The Dems. just lost 4.5 MILLION voters.🔴
66.3K62 -
1:04:10
BonginoReport
8 hours agoCornhusker Clink & A Sizzling Border Wall Deter Illegals - Nightly Scroll w/ Hayley Caronia (Ep.116)
128K89 -
10:22:43
ZWOGs
13 hours ago🔴LIVE IN 1440p! - SoT w/ Pudge & SBL, The Finals w/ The Brrrap Pack, Kingdome Come - Come Hang Out!
13K1 -
3:17:53
VapinGamers
4 hours ago $0.90 earnedOff The Grid - Yes I Have a Problem but Winning Aint One! #1 Controller Scrub NA - !rumbot !music
11.1K1 -
3:02:09
XxXAztecwarrior
5 hours agoThe Finals W/ The Tribe
7.22K