Better Excel Variance Charts to show percentage change (Simple & uncommon technique)
Apr 6, 2017 Excel Charts
Complete Advanced Excel Chart Course: https://courses.xelplus.com/p/excel-charts-visualization-secrets-for-impressive-charts
In a previous video (https://rumble.com/v2skmji), I showed you how you can use conditional formatting in Excel Column or Excel Bar charts. I also showed you how you can conditionally format the data labels in Excel graphs to show a different color if the values are positive to when the values are negative.
What I didn't like about that chart was that it was too bulky - and it took away attention from the main column chart that showed the actual sales numbers.
In this video, I show you how you can use the Excel error bar technique to create really thin bars (or thick lines) which has a more subtle effect. The result is a visually effective chart that doesn't distract the readers attention from the main chart but also communicates the difference to previous year visually as well.
The chart doesn't just use the error bar technique but it also conditionally formats the bars so they are green if the data points are positive and red if the data points are negative.
This technique works for Excel 2007, 2010, Excel 2013 and Excel 2016.
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ 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/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
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
-
5:41
GOGUYGO
2 years agoSupport & Resistance, Reading charts simply
15 -
1:00
Performing in an Academic Environment
3 years ago $0.01 earnedMicrosoft Excel Tutorial - Pivot Charts
59 -
44:43
Microsoft Excel Full Course
3 years agoExcel 365 Part 14 – Chart
91 -
24:18
Homeschool Math
3 years agoPercent of change: word problems - IXL A1.D.5 (59V)
8 -
29:03
excelsoftware
2 years ago $0.01 earnedSpreadsheet with Dynamic Charts
28 -
0:51
Dinâmica Digital
1 year agoHOW TO CALCULATE PERCENTAGE [%] IN EXCEL
12 -
0:11
SKILL-LAND
9 months agoSales trend chart in Excel ✓ Draw Excel chart ✓ Excel tricks ✓ Excel tips #excelchart #excelshorts
7 -
19:27
AccountingInstruction
7 months agoAverage Deviation 1428 Statistics & Excel
-
5:13
Tuts4dummies
9 months agoExcel | VBA | How to Add Chart
265 -
44:54
Crypinfo
11 months agoBTC ANALYSIS & CHART PATTERN
138