# Tips and Techniques: The formula bar

Klipfolio  is a powerful tool when it comes to manipulating data and providing key insights into your data. In this introductory article, you build a Klip using the formula bar. This Bar/Line Chart shows the top three fruit types as a percentage.

In the Klip Editor, select the X:Axis

Use the Insert data from a data source (Alt+A) button to select column `A` from the data source.

To check that the names of all the fruit types are returned, select column A:A in the formula editing toolbar, and then select the Evaluate current selectionbutton.

Next, select the Wrap current value in function button and select Data Manipulation, SLICE to remove the column header from column A.

An element of the SLICE function is start. Select start and then select the Insert literal string or number button and type 2 to start at line 3 of the data source, as (not set) is not a fruit type.

Select Series.

To start off this formula, select the Insert expression in parenthesis button.

Select the `SLICE( A:A , 2 )` function from the X:Axis and use Ctrl+C and Ctrl+V to copy and paste it to the Series, and change the column A:A reference to column B:B.

Select the first ellipsis, and then select the mathematical operator Divided by `/`.

Select the the Insert function button, select `SUM` and for the data element select column B.

Select the second ellipsis, outside the round brackets, and the mathematical operator Multiplied by, and then select the Insert literal string or number button to type 100. Select the Y:Axis Properties panel, Format as to Percentage.

Tip: You can use the Undo change to formula (Alt+Z) button if you made a mistake.

To sort our Klip to display just the top 3 fruit types, apply the `SORT` and `SLICE` functions.

• Select the `SLICE` function for the X:Axis formula, and then select Wrap current value in function, Data Manipulation, SORT.
• Use Ctrl+C and Ctrl+V to copy the `SLICE( A:A , 2 )` formula to the element returning values.
• Change type to descending numeric.
• Copy the Series formula: `(SLICE( B:B, 2 , end ) / SUM( B:B )` over the first occurrence of `SLICE( A:A , 2 )` at the values element.
• Wrap the `SLICE` function around the whole X:Axis formula specifying a start of 0 and an end of 3.
The finished formula looks like this:
`SLICE( SORT( ( SLICE( B:B , 2 ) / SUM( B:B ) ) , descending numeric , SLICE( A:A , 2 ) ) , 0, 3 )`
• Wrap the `SORT` function and then the `SLICE` function around the Series formula. As you are sorting by the Series formula, you do not need to copy the Series formula to returning values.

The finished formula looks like this:
`SLICE( SORT( ( SLICE( B:B , 2 ) / SUM( B:B ) ) , descending numeric , 0, 3 ) * 100`