Create a Custom Number Format for a Chart Axis

After you've created a chart (like a line or column chart) Excel usually give you some default format for your x or y axis.  For the most part, Excel is "guessing" your numerical or alpha values and giving it's best shot on the type of labeling for the axis.  Sometime that's acceptable but other times it just doesn't make sense.  You'd think Excel was smart enough to read your mind and figure it out for you.  We are not there yet BUT you do have the option of customized the format of the chart axis to some extent.  What kind of customization can Excel do?  Well for example you want the Y axis to have different colors at some mid-point like the axis label numbers above 100 are red colored and the ones below it are green colored.  See the video to learn how this is done.

Filter Unique Values from a List

Whether you have a small list or large list of items if you wanted to do analysis, you'd have to do some kind of filtering to teased our important information. In this video, I'll show you how to filter out unique values from a list in a column. I'll show three ways to do this: (1) with a PivotTable (2) with the Advanced Filter feature (3) with the Remove Duplicates feature .

Highlight Parts of a Line Chart

Check out my Blog: http://bit.ly/2PGzLOL You create a line chart and want to mark some areas of significance. Maybe the line chart showed sales and there are some area where there was a market downturn so it could help explain why the sales were impacted in those months. You may have seen this type of chart where it tracks the Dow Jones Average and there is somewhat of a shaded area that shows the months where there was a recession. This chart is not exactly like that but it is similar. And it's easy to create, so check out the video to learn how. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel #excel101 --------------------- Excel Training: http://bit.ly/2vtLaYS Excel Books: https://amzn.to/2PHj3yC

via https://youtu.be/IPHbWUApFhk