Command Overview

The bottom 5 command ("b5") lists the five smallest items within the range selected on the Excel worksheet.

Syntax

The bottom five command is entered on the toolbar as "b5". Optionally, the title to be displayed can be entered as title=Text of the Title to Display"

This results in both a graphic (shown below) as well as logging the amounts on the status bar and on the log sheet ($Log).

Information shown on the toolbar:

Once the command is processed, a chart is displayed

It is also possible to select just a portion of the worksheet using the technique of highlighting. Further details are available.

Main Form