by Nate Moore | Feb 23, 2015 | Charts, Excel 2013
I have two more Data Label tricks in Excel Video 448. First, watch for a way to use cells outside of my chart as Data Labels. In today’s example I’ve characterized the data as High, Avg, or Low using formulas to see if the data point is significantly higher or lower...
by Nate Moore | Feb 16, 2015 | Charts, Excel 2013
Data Labels are a way to provide additional information about data in your chart. Excel Video 447 shows you how to start using Data Labels. Today I’ll show you what a Data Label is, some options on how where to position Data Labels, and some ways to change the content...
by Nate Moore | Feb 9, 2015 | Charts, Excel 2013
Excel Video 446 takes our discussion of Chart Titles to the next level. Watch how I use = to point the Chart Title to a cell where I can combine text and formulas to get much more customized titles. If you aren’t familiar with the INDEX and MATCH trick I use in the...
by Nate Moore | Feb 2, 2015 | Charts, Excel 2013
Excel Video 445 is the first of two videos on using Chart Titles. Watch for ways to change the location of the Chart Title and for suggestions on what to put in the title. Rather than a generic title like, “Charges by Month” you may find it more helpful to reinforce...
by Nate Moore | Jan 26, 2015 | Charts, Excel 2013
There are three things to consider as we discuss axis titles in Excel Video 444 today. The first point is that axis titles are often redundant. The titles take up space on the chart but many times a reader can use the fact that the axis is formatted with a dollar sign...
by Nate Moore | Jan 19, 2015 | Charts
In Excel Video 443 we’ll make more changes to the horizontal and vertical axes. We’ll format the numbers, change the direction of the text, and change the font color. Notice how it’s often easier to just format the raw data the way you want the chart to appear, but if...
