Premium Only Content
![This Excel Chart will grab your attention (Infographic template included)](https://1a-1791.com/video/s8/1/e/0/x/e/e0xek.qR4e.1-small-This-Excel-Chart-will-grab-.jpg)
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:22:27
Steven Crowder
2 hours agoGeorge Washington, Our First President | 3 in 3 Special
160K111 -
1:03:57
Kyle Fortch
3 hours ago $0.70 earnedDJ Chill: DJing For Jelly Roll, SOLD OUT Tour, Performing at Hometown Arena | THE ONE SHEET S1E4
10.2K3 -
4:05:26
The Pete Santilli Show
14 hours agoThe Deep State Spied On Trump & Sabotaged 2020 Operation To Oust Maduro [EP 4440-8AM]
20.5K3 -
41:53
Rethinking the Dollar
1 hour agoHype or Hope? Will THE 50-YEAR FORT KNOX GOLD SCANDAL BE EXPOSED?
5.83K2 -
1:32:36
Game On!
16 hours ago $8.63 earnedPresident Trump TAKES OVER the Daytona 500!
44.4K13 -
21:35
DeVory Darkins
3 days ago $25.28 earnedMitch McConnell TORCHED as Secretary of HHS is sworn in
134K190 -
1:20:04
Tim Pool
4 days agoGame of Money
183K12 -
4:48
Cooking with Gruel
17 hours agoThe Perfect Bacon
24.9K5 -
11:49
Reforge Gaming
4 hours agoXbox - Next Game on PlayStation?
17.6K4 -
27:46
ArturRehi
1 day agoSurprise Counter-Attack in Kursk Advanced 3 Miles | French Jets Arrive | Ukraine Update
27.7K8