How to customize a category axis
In this video, we'll look at options for customizing a category axis in an Excel chart...
Dave Bruns
How to reverse a chart axis
In this video, we'll look at how to reverse the order of a chart axis...
How to create a multi level axis
In this video, we'll look at how to build a chart with multi-level axis labels. A multi-level axis allows you to group related information together...
How to add a secondary axis to a chart
In this video, we'll look at how to add a secondary axis to chart. A secondary axis allows you to data with a different scale in the same chart...
How Excel plots dates on a chart axis
In this video, we'll look at an example of how Excel plots dates on a horizontal axis, and some ways you can control the axis when working with dates...
An introduction to chart axes
In this video, we'll take a look at the different axes (horizontal, vertical, etc.) you'll find in Excel charts...
Get first entry by month and year
Note: the values in E5:E8 are actual dates, formatted with the custom number format "mmm".
Working from the inside out, the expression:
MATCH(TRUE,TEXT(date,"...Read moreValue is within tolerance
In this example the goal is to check if values in column B are within a tolerance of .005. If a value is within tolerance, the formula should return "OK". If the value is out of tolerance, the formula should return "Fail". The expected value is listed in column C, and the allowed tolerance is...Read more
Get last entry by month and year
Note: the lookup_value of 2 is deliberately larger than any values in the lookup_vector, following the concept of bignum.
Working from the inside out, the expression:
(TEXT($B$5:$B$13,"mmyy")=TEXT(E5,"mmyy...Read moreARABIC Function
The ARABIC function converts a Roman numeral to a number in Arabic numeral form. The result from ARABIC is a numeric value.
ARABIC takes just one argument, roman_text, which should be a Roman number provided as a text string. For example, the...Read more