I will talk you through all the different elements of formatting charts, with some tips and tricks along the way. We'll go from a basic default chart and end up with something that looks infinitely more presentable.FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
I'm going to go through seven key tips on improving Excel chart appearance and we're going to end up producing the chart on the video thumbnail. We’ll go through it step by step so we're going to start with some basic data, highlight that using some keyboard shortcuts that you'll see on your screen, and then hit ALT+F1 to give an instant chart on the screen that we can then use.
Today we're going to be focused on the format tool bar and all the different aspects of this.
7 Tips for Improving Excel Chart Appearance:
1» Clean Chart Area
2» Titles
3» Axes Text Wrap
4» Data Labels
5» Chart Types
6» Colours and Highlights (How to Automate this:
7» Using Shapes
I've done an entire video going through all the different aspects of chart design, so if you want a reminder, or you want to go through that first, check out my previous video here:
In the next video I'm going to be showing you how to use trend lines on charts to produce forecasts within the spreadsheets themselves. You will be able to forecast forward data using trend line analysis on your charts. Make sure you subscribe and hit the bell icon so that you can be reminded when that video comes out.
Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training. Here’s some of the things you could do with the time you’re going to save:
» Invest in yourself, saving even more time with Up4Excel training videos
» Spend more of your time on interpreting rather than compiling reports
» Get ahead of the game and accelerate your next promotion
» Or perhaps leave work on time, or even early, and enjoy your home life
We release a video every week, packed full of ways to save time and impress those around you. Make sure you subscribe, and hit the bell icon, so you don’t miss out and fall behind!
Here are links to some other videos you will find useful on chart techniques:
» Excel Charts Made Easy: Excel Charts and Graphs for Beginners
======================================================================================
The Webcam I Use:
Logitech C920 HD Pro Webcam, Full HD 1080p
https://amzn.to/2nlc9FE
Recommended Advanced Formulas Book:
Ctrl+Shift+Enter: Mastering Excel Array Formulas (by Mike Girvin of ExcelIsFun fame)
https://amzn.to/2ofPytU
======================================================================================
Get more FREE Training on Up4Excel here
»» https://cutt.ly/ewsz9Sn
FREE Shortcuts Cheat Sheet
»» http://www.up4excel.co.uk/shortcuts
======================================================================================
▶️ DTube
▶️ YouTube